Hi team,
Sorry for my poor grammar but english is not my mother tongue :-)
I'm facing an issue displaying % in Pivot Table.
If u have a moment, please take a look on my Pivot Table in attachment
I would like to see % on the same line as my calculated field. This is a requirement and mandatory for my customer.
Actually calculated fields and % are on different lines.
I'm totally free to change the structure of the data source with VBA or Powerquery (depivot fields, etc...) but the final result must be a Pivot Table with % based on grand total of each measure (qty, revenue) like displayed in right side of my excel attachment (this is the final table for my customer).
What i've done but unsuccessfully:
- trying to use in a data model, transforming with OLAP formulas then adding manually % columns but result is definitively not a Pivot Table and not so esay to manage for my customer.
- trying to add measures with PowerPivot but i'm not able to obtain the result expected for my client
- playing with calculated fields in Pivot table but same issue
- depivot each measure (qty, revenue) in Powerquery
What i need to investigate:
- changing the structure of my data source to be easily compliant with the final result.
Any help would be greatly appreciated.
All my best from France
Phil
Bookmarks