Hi everybody!
First, sorry for my english
I need some help. I'm triyng to make a pivot table using Power Pivot
My table looks like this:
Date Name Value Weigth 05/05/2019 Keenan Bartel 1200 5 11/01/2019 Annabel Brown 1700 2 19/01/2019 Keenan Bartel 500 7 23/03/2019 Mark Zuck 1600 9 ... ... ... ...
In Power Pivot, I created a calculated column:
- Value x Weight: this is to calculate the total weighted value
An I created too 4 measures:
- Weighted Value: it's the sum of the "Value x Weight" column
- Total Weight: it's the sum of the "Weight" column
- Weighted Average: this is the division of "Weighted Value" by "Total Weight" measures
- % of total: this is division of the Sum of Value (with filter) by the Sum of Value (without filter, using the parameter "All")
Now I want to create a pivot table using the Names as row, the Weighted Average as value, the % of total as value and the Date as column. But I want that the % of Total not to be expanded in date columns, only the Weighted Average, like this:
(the values is just for demonstration)
Values Date Names % of Total Jan Fev ... Keenan Bartel 8% 1437 590 ... Annabel Brown 6,7% 297 675 ... Mark Zuck 5,81% 157 0 ... ... ... ... ... ...
How can I do that?
Bookmarks