Set analysis and intersect

[mustafaelryah]

Dear All,

I used set analysis to avoid showing one value , take a look to the below picture :

I don't want (NON-Budgeted ) to appear on this chart, so I used the below Set Analysis:

Sum({$<Account_Budget -= {'NON-Budgeted','-','0'}>} balance)

this hide the value of (NON-Budgeted) but the label is still shown on the chart, what could I do?

Regards

[mustafaelryah]

Thanks a lot Sasidhar Parupudi

[jagan]

Hi Mustafa,

Calculated Dimension have performance issues, so it is suggested to use set analysis like below

Sum({<Account_Budget={'ON-Budgeted'}>} Account_Budget)

Hope this helps you.

Regards,

Jagan.