Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we hide the dimension fron the cyclic group?
For example
Incyclicgroup we have Date, month and Year and if(isshow=1) then need to hide the year dimension from the CG.
Can we do this,
thanks in advance.
Hi ,
1.Use this expression for Year in creating group
= If(isshow=0,Year,Null())
In Presentation tab of the chart-> In the Null symbol box give a space
2. create 2 groups
1 with Year (Say Group3 )and 1 without Year (Say Group2)
Now add calculate dimension like
= If(isshow=0,[Group3],[Group2])
Hope this will helps you..
Either of the one in above
Hope this helps you.
vikas
Is your second choice working?
I tried like this in Pivot table but it is not working.
=if($(isOrdinaryCalendar)=1,[cgInvoiceDate], [cg_FiscalDate])
Regards,
Kabilan K
If I am using first choice, I got one empty dimension in cyclic group ryt.?
How to avoid it?
Hey I was not tried like that, it was just an idea of myne.
Try like this, I tested and it will work
Create a variable vShow and
add those 2 groups as 2 dimensions and conditional enable expression on each of those like
Dim1 -> Group1(Field1,Field2,Field3) -->Condition : vShow=0
Dim2 -> Group2(Field1,Field2) ---> Condition : vShow=1