Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts. I need your help
I want to hide last row in dashboard
I used this formula:
=If(match([PORTFOLIO__LINE],'Retail'),Dual('Retail LP',0),
If(match([PORTFOLIO__LINE], 'corporate'), Dual('Corporate LP',1),
If(match([PORTFOLIO__LINE], 'SME'),Dual('SME LP',3),
If(match([PORTFOLIO__LINE], 'RETAIL'),Dual('Plastic Cards',4),
If(match([PORTFOLIO__LINE], 'Individual TD'),Dual('Individual TD',5),
If(match([PORTFOLIO__LINE], 'Legal TD'),Dual('Legal TD',6),
If(match([PORTFOLIO__LINE], 'Retail CA'),Dual('Retail CA',7),
If(match([PORTFOLIO__LINE], 'Corporate CA'),Dual('Corporate CA',8),
If(match([PORTFOLIO__LINE], 'SME CA'),dual('SME CA',9))))))))))
But i can't hide.
Please help 🙏
You should be able to Uncheck "Include Null Values" on your dimension Bar.