Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a excel document called Software and one of the sheet is called Summary. In the Summary section I have entered the data, Oracle, Password Reset, Cyborg and Other. The Pie chart that I created shows all these values, however I want to remove Password Reset from the pie chart, so the pie chart only shows, Oracle, Cyborg and Other.
I tried using the below code in my expression editor in the dimension section, but I get a Error in Expression.
=IF(Software.Software='Password Reset',IsNull(),[Software.Software])
Does anyone know how I can do this please?
Jon Ditchfield
Sorry missread, the formula should not be in the dimension but in your expression
Something like:
=IF(Software.Software='Password Reset',0,Sum(Value))
What if you try:
=IF(Software.Software='Password Reset',0,[Software.Software])
?
Hi Dennis,
The Password Reset values changes into a 0 but the data still shows on the pie chart.
Also if you check "Supress Zero-Values" op the presentation tab?
The data in the ledgend still shows as a 0 instead of password reset, but the value still shows on the pie chart.
Sorry missread, the formula should not be in the dimension but in your expression
Something like:
=IF(Software.Software='Password Reset',0,Sum(Value))
Dennis you are an absolute ledgend thanks for your help it worked wonders.