Hi,
I need to compare some values based on first value in Label side. I am using Pivot feature show values as difference from.
The problem is that this feature works only for first Label group, for the other it doesn't because data is dynamic and not same. How can I avoid this?
The 2nd problem is that in this feature Pivot do not shows values of first row in Label group. How can I set it to show up?
Example in attachment.
P.S. If not possible via raw pivot, I would like to add helping column in data sheet, then try Pivot.
Best regards
Bookmarks