expression unshow

[#1]

Hi,

I need some inputs on the pivot table expression hide.

I need to hide the Actual column for FULL YEAR dimension.

the actual column for PERIOD & YEAR-TO-DATE should remain the same.

Any help would be highly appreciated!!!

[maximiliano_vel]

If you only need not to show the result of Actual for FULL YEAR then perhaps you could try

=if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'PERIOD',sum({<month ={$(vMTDPeriod)}>}Actual),

if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'YEAR TO DATE',sum({1<Year ={$(vYTDYear)}>}Actual),

if([P&L ACCOUNT] <> null() and [P&L Level] <> 's' and valuelist('PERIOD', 'YEAR TO DATE','FULL YEAR')= 'FULL YEAR','','')))

Or Please post the expected results.

Regards

[antoniotiman]

So, if I have understood like this

[#4]

Thanks for the quick response Maximiliano,

the values are not showing but the entire column should be deleted along with the columns

please look into the required output. look at the red colored circle on full year dimension

[#5]

could you please do help ?

[maximiliano_vel]

I'm sorry is something Like this? Please elaborate...

[#7]

Hi Maximilinao,

please could you remove the complete column that i rounded with black colour?

Only the Actual column in Full Year has to be removed, the other columns in Full year has to remain as it is.

[#8]

bump

[maximiliano_vel]

Hi, well i'm sorry to tell you that i didn't find a way to remove the column Actual ONLY for dimension FULL YEAR, the max i could get was zeroing the column Actual

When you remove the column Actual from the pivot table, it remove it from all dimensions.

[antoniotiman]

I'm sorry, I agree  too.

Regards