Search results

Regarding the same above Isuue, I sorted my data and only put the unique values in one sheet. But when updated the data and tried to relate it is showing the same error. May be because it has empty rows in the table. How to delete them from the power pivot table.

How to change the selection area of a table that we have already selected in powerpivot table while importing data through Creating Linked Table. Even if I delete the previously selected table and creating a new table fromt he old data i am not able change it. plzz help...

Hi, Thanks for the reply. . . It is ok for this case. Suppose if I have 3 calculated fields in the Pivot Table I can't do all the calculation in the original sheet. So please suggest me an alternative solution.

Dear all, I have been facing this problem recently. Using slicers I am not able to sort the data as I wish. It is giving the intersection of the data but not the union. For Example: I have a data like name desig points 2011 points 2012 ws we 21 0 s ds 21 23 ds fg 0 34 d fgcd 23 25...