Expression that shows curtain data

[Anonymous]

Hi, QV Community

I have a data that is wrong and I can't change it.

But I want to make the expression that shows the data the way I want

here is an example of how the data is:

Sales nr.	Customer	Category	Sales
1	Benz	Motorcycle	356.443
2	Benz	Family Car	458.236
3	Benz	Family Car	515.862
4	Nissan	Small Car	315.448
5	Nissan	Family Car	698.523
6	Nissan	Motorcycle	155.869
7	VW	Family Car	200.125
8	VW	Motorcycle	486.953

I use the expression Sum(Sales). Then I select Family car and small car.

Then I got the data I want. But then I saw that the data was inaccurate.

Sales nr. 8 was wrong. It has the wrong category. It has Motorcycle but was supposed to be Small car.

I can't change so I was trying to figure out if I could make an expression that shows Sum(sales) and sales for VW for category

thanks in advance

Darri

[sunny_talwar · Accepted solution]

Try this expression:

=Sum({$+<Customer = {'VW'}, Category>}Sales)