I have a table with different types of demands showed as 1 column for demand category and another for value; + column for plan date, another for planning time, item ID, customer ID... It means, there are demand planning categories and those show different demand values per months.
I would like allow the users to select between these different attributes (whatever 2 categories they want to compare) and the table to return the absolut delta between them, the % and the share of delta from the total of those 2 attributes.
And until now, I could not find a solution for this. Do you have any ideas?
(I tried to create 2 slicers – but it did not work, and I did not have any idea how to show the differences)