Forum Discussion
Show or Hide Pivot Table Column Conditionally
mfarsln you can surely achieve this by measure returning blank value if date is not the last date but that totalpbamount measure will still be under each date with no value and only show values on the last date, would that work?
Hi parry2k
Thanks for your quick answer but the real challenge that i'm facing is to not see totalPbAmount column under other dates.
mfarsln unfortunately that is not possible, you can hide the value thru measure but you cannot complete get rid of the column
Thank you so much mwegener it worked.
But one last thing. If i don't filter date field it works perfectly. But if i filter date, say i select 01.01.2019 and 01.02.2019, it still recognizes 01.03.2019 as last date. So it shows pbamount for both dates. pbamount should only be visible under the last date of the given context.
And what is the logic behind these 1 and 2? I couldn't get what those numbers represent here.