Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have combo chart with title,along with title i want to display one-by-one field names.
Ex:- My title is Brand analysis and i have different fields like field1,field2,field3 in three different dimensions.
When i selecting one-by-one fields,I want output like this in caption,
Brand analysis-field1
Brand analysis-field1-field2
Brand analysis-field1-field2-field3
like this i want in caption..
any one having the idea about this.
Regards,
baru
Try this:
='Brand Analysis '
& if(not isnull(field1),'-'&field1)
& if(not isnull(field2),'-'&field2)
& if(not isnull(field3),'-'&field3)
Try this:
='Brand Analysis '
& if(not isnull(field1),'-'&field1)
& if(not isnull(field2),'-'&field2)
& if(not isnull(field3),'-'&field3)
Hi Baru,
You need to use something like this :
'Brand Analysis - ' & Concat(Distinct Subfield( GetCurrentSelections('==', '=='), '==', ValueLoop(1, 1000, 2)), ' - ')
This expression works on all the charts and irrespective of any dimension. However, you need to change the ValueLoop contents where I have used maximum value as 1000 but you can use any value based on your dataset.
Cheers,
DV
Hi Phil & Deepak,
Thanks for your reply and solutions.
Regards,
baru