Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Namaste,
I am using below Set analysis for showing the balance of a Business Line as on "Keydate"(KeyDate_Pr_Month)
(Sum({<POSTDATE={"<=$(=(KeyDate))"},CLEARDATE={">$(=(KeyDate))"}>}USD)+
Sum({<POSTDATE={"<=$(=(KeyDate))"},CLEARSTATUS={'OPEN'}>}USD))/1000
It is giving correct result in My Pivot, Now i am trying to show Top 10 Business line only in Pivot how do i achieve it.
I tried Vizlib Pivot to show Top 10 but issue is after 10 items it is showing other as well as Null. I just want to see Top 10 nothing else.
Any suggestion?
Thanks
In Pivot Table there will be an option to include or exclude NULL values under each dimension, use that check box it will solve the purpose.