Hi,
I am facing problem in doing drill up and drill down in power pivot. i have the values in percentage and when i do the hierarchy for few data and export the data into pivot table in power pivot and percentage are showing up in counts and when i change the count into sum or average i am getting error has - we can t summarize this field with sum because it's not a supported calculation for text data types.
i have given the data in the attachment. Could you please help me with the Drill up/down - i need it in percentage which i am getting in count after doing the pivot table.
I am facing problem in doing drill up and drill down in power pivot. i have the values in percentage and when i do the hierarchy for few data and export the data into pivot table in power pivot and percentage are showing up in counts and when i change the count into sum or average i am getting error has - we can t summarize this field with sum because it's not a supported calculation for text data types.
i have given the data in the attachment. Could you please help me with the Drill up/down - i need it in percentage which i am getting in count after doing the pivot table.