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:
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