2 different attributes' selection of the same category and difference calculation between them

[csatary]

Hi Everyone,

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)

Thank you!

Regards,

Ágnes

[TomMartens]

Hey,

I have to admit that I got lost about your table structure (the columns in your table), your requirement and the expected result.

At least to it would be helpful if you could prepare a sample file, upload the file to onedrive or dropbox and post the link.

Regards

Tom

[csatary]

Hi TomMartens, Everyone,

see the capture of my example table