Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bar chart in which i am using a drill down group as dimension. Group comprises of 2 calculated fields
1. A calculation that brings an Year
2. a calculation that gives the name .
So these two fields make this dimension group .
Now in my expression I want to use Label which changes on basis of Year.
Eg. for
year 2013 : Text pop up(Label) should look like Year =2013
Actual = 70%
2014 Year = 2014
Actual/Forecast=78%
2015 Year=2015
Forecast=89%
So as stated ,here Label changes dynamically on basis of year and year comes from the Dimension Group.
How to make these Label dynamic
Please revert it asap.
Thanks,
Vijit
Hi Vijit,
You can use this functions :
getcurrentfield (GroupName)
and Concat(distinct Field,',')
François
My group name is : Planned Year-Month
And formula in Label expression :
This is not working for me .Check it once
Vijit,
Can you send an application with a simple example.
It would be better to correct your formula.
Thanks,
François
Try something like this
IF(GetCurrentfield("Planned Year-Month")='Projected vs Plan.Year',
IF([Projected vs Plan.Year]='2013','Actual'))
This is not working Pradeep.
Hi,
Please upload same data, if possible with the APP.
Best Regards,
Gabriel