Drill down on piecharts

[nkosinde13]

Good day community

I need to your assistance with drilling down on pie charts:

The hierarchy that I'm using is Category, Department, Account,  Media Consol, Media Group and Business Unit  in that order

1st pie chart needs to have this drill down: Category, Department, Account

2nd one: Media Consol, Media Group ,Business Unit

The  problem comes the minute you drill down to the charts. Since the revenue calculated has both negative and positive values, the drill down seems to be excluding the negative values .

I'm using the below same expression on both charts. I've attached a document with more details and examples Expression is : NUM(IF(Sum({<$(eSetFYTD_CN)>}Amount)>0,Sum({<$(eSetFYTD_CN)>}Amount) / $(ThouMenu)),'R# ##0')

Any assistance is highly appreciated.

Regards Matlotlo

[wade12]

pie charts are typically used in data visualisation to indicate ratio.

perhaps you should convert your -ve numbers into +ve numbers using an absolute value function.

then display them on the pie chart but usee some way (e.g.  notation, colour, etc.) to distinguish them from the +ve values.

best wishes.