Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
let say this is the data from my excel file.
Shop | Product | Sales |
---|---|---|
A | DDD | 300 |
B | DDD | 400 |
TOTAL | 700 |
For some reason, the TOTAL rows i need to keep in the excel file.
There are 21 shop in the excel
so when i use formula:
SUM(Sales)
The result = 1400.
so how to filter it?
Thank you in advance!
change ur measure as folow:
sum({<Product-={'TOTAL'}>}Sales)
Hi,
Try this:
SUM({<Product -={'TOTAL'}>}Sales)
Hope this helps,
Justin.
Thank you so much!
thank you !