Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have listbox called status
status:
statusA
statusB
i have a chart with dimension as status and expression as sum(sales)
my req is when i click on statusA i want see 100% sales and when statusB i want see 50% sales how?
Thanks in advance
Hi Manoj
Use set analysis
=if(Status = 'StatusA', sum(sales),
if(Status = 'StatusB', sum(sales)/2))
Thanks and regards
PAdma