Show Hide expression on basis of dimension

[#1]

Hello Everybody,

I need your help,

I was trying to show hide an expression on basis of the dimension in Pivot table but was unable to.

Example,

When dimension is Retail all expression should be enabled but when dimension is Group some expression should be disabled.

I was trying to do it by conditional functionality in QV 11, but the if statement was not working.

When I use to select the dimension it works fine but I do not have to select this dimension...

Please help me out, if any solution is available.

[#2]

Hi,

Please find the attached file Hope it helps you

[#3]

Thanks for your reply,

But your example is as same as we can do by making selections.

I need to show both dimension value at same time as I have shown in my screenshot.

Any idea for having specific format.?????

[#4]

I think its only possible if both dimension (ie Retail-Group and FTD..MTD etc) are pre calculated....

Find attached example

[#5]

i dont know if i have understood your requirement right.

But please try this

IF(Getcurrentfield(Dimension) = 'Group',0,1)

Use this in the condition for the expressions you want to hide

[#6]

Hi Pavan,

Thanks for your reply,

But getcurrentfield takes only the group name as argument.

And in  my issue I am having only normal dimension and not group.

[#7]

In your load script,

Load *,

IF(Dimension='Retail',Dimension) as Dimension1,

IF(Dimension='Group'Dimension) as Dimension2

FROM yourtable;

Now,you can use these two dimensions 'Dimension1' and 'Dimension2' to create a cyclic group and use the expressions in my previous reply.

I dont know if this is the best solution,but this is what came to my mind.

Thanks,

Pavan