Hi,
I have created a pivot table based on power pivot model.
I have many rows and columns in the data source all of them are text beside one column that has values in it.
when i am creating the pivot table the pivot is showing only the rows that have values in it.
rows the the the column with the values doen't not have any values in it are not showing in the pivot table.
how can i fix it and make the pivot to show the rows that does not have any values in it.
Thanks
Bookmarks