cancel
Showing results for
Did you mean:
Regular Visitor

How to find differences between sales value based on product type column and category column

Hello,

I want to find sales value difference between the product and  category.

for eg :

(product A and category 0) has \$100 sales and the (product B and category 0) has \$50 then the reult in difference coulmn would be 50. Screen shot below with yellowhighlighted column.  Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

Re: How to find differences between sales value based on product type column and category column

Hi,

Try this calculated column formula

=ABS([Sales]-CALCULATE(SUM([Sales],FILTER(Data,Data[Category]=EARLIER(Data[Category])&&Data[Product]<>EARLIER(Data[Product]))))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3
Super User

Re: How to find differences between sales value based on product type column and category column

Hi,

Try this calculated column formula

=ABS([Sales]-CALCULATE(SUM([Sales],FILTER(Data,Data[Category]=EARLIER(Data[Category])&&Data[Product]<>EARLIER(Data[Product]))))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Highlighted
Regular Visitor

Re: How to find differences between sales value based on product type column and category column

Thanks for the response Ashish...

Super User

Re: How to find differences between sales value based on product type column and category column

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements