Hello,
I have a pivot table where i would like to show the values as percentage of a fix value.
My problem is that I want the percentage of the values in level 2 on a single value of level 1.
In the attached file you see in yellow the correct percentage of all the values of level 1 but for the data of level 2 i can't have any percentage back.
do you have any suggestions?
thanks
I believe that requires Power Pivot and some DAX measures. Can you upload an Excel file? Otherwise it will be difficult to help you further. And can you explain for some of the "green" cells what the percentage should be? Just to avoid any confusion regarding the expected results.
Hello,
Thanks for your answer, attached the file you have asked.
I put the percentage expected in the "Cee CE" hope you can help me
