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