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:

Values Date
Names % of Total Jan Fev ...
Keenan Bartel 8% 1437 590 ...
Annabel Brown 6,7% 297 675 ...
Mark Zuck 5,81% 157 0 ...
... ... ... ... ...
(the values is just for demonstration)

How can I do that?