Add custom calculation while generating Pivot table in BI using custom DM

kmanda

Description

Does anyone know how to create % of Grand Total or % of row total during pivot table generation using custom DM (just like pivot options in Excel)? I only see count, count distinct enabled and the rest of aggregation options are grayed out. 

Use Case and Business Need

We need to display the % of the row total and grand total

Original Idea Number: 570d00b3c5

Ryan Burns

Yes! This would make our reporting much more powerful.

User_0MEFO

Seems like a really reasonable and much needed request!  

Sailee Deb

We are also having same requirement