Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to be able to only see certain customer numbers but I dont want to select them.
So if I had 3 customers A, B and C if I only want to see customer C I could just select customer C but it will flow through all reports and also effect totals, formulas etc
I want to tell the chart to only show certain customers so that the non selected customers are still there just invisible and the totals arent affected
Thanks
David
It can be done using putting if conditons in the expression
ie, if you are displaying Customers vs Sales, then the sales expression should be:
if(Customer='A',sum(Sales),0)
Suppress Zero Values (Checked)
This way the chart will only display Customer A