Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I attached the data which i used and also i have attached the table screenshot.
for the company C , we dont have any data. but in the table we can see 0 as a value.
so i dont wnat to show the 0 for the company C. i want to show 0 only for B as it has the values 0 for sales.
Could you please help me with the solutions.
Add to your expression set analysis
…., sales={“*”}
@PoojaS
maybe this:
sum({<category={'Mobile'},sales-={""}>}sales)
Regarts, Matheus