rolo
Member
I have this report built with regular Excel fórmulas:

I need to replicate this report with Pivot Table.
I was able to do it, but I have this problem:
I have DAX measures for Margin (gross, net and %) which you can see in rows.
I was able to show them on pivot table rows without problem.
Then I have DAX measures for Variance (absolut and %) which you can see in columns.
But when I try to show these variances in pivot table columns I can´t.
Seems like DAX can only be rows or columns and not both!
Is it possible? Any solution for this?
You can see attached example
Thanks in advance for any help

I need to replicate this report with Pivot Table.
I was able to do it, but I have this problem:
I have DAX measures for Margin (gross, net and %) which you can see in rows.
I was able to show them on pivot table rows without problem.
Then I have DAX measures for Variance (absolut and %) which you can see in columns.
But when I try to show these variances in pivot table columns I can´t.
Seems like DAX can only be rows or columns and not both!
Is it possible? Any solution for this?
You can see attached example
Thanks in advance for any help
Attachments
-
155.6 KB Views: 2