Forum Discussion
Solved
PowerPivot Table - Total Column as a Multiplication of Values
Good afternoon, I am trying to create an additional total column in power Pivot Table as per the yellow highlighted column in my Snip Below: The Total Rate is the "Rate" column, multipled by ...
As variant you may add row with Rates moving Values into Rows section
Not to show in each column measure could be
Rate total::=IF( HASONEVALUE( Table1[Date]Table1[Date]), BLANK(), [Rate] )
Thanks Sergei, thats ideal!
TamlerloversKant , glad to help
