Alternate state with chart dimension

[#1]

Hi friends,

I want to show comparative analysis in pivot table where I have to show the selected dimension value for each alternate state group.

I dont know whether it is possible or not,but if anyone has any idea or suggestion please share with me.please find attachment for a sample application

[morgankejerhag]

Hello,

Maybe you can set the label to:

=concat({State1} distinct Client,',')

This will contatenate all possible values from field Client. See attached file.

Best regards,

Morgan Kejerhag

Senior Business Intelligence Consultant, Drake Analytics

http://www.drakeanalytics.se

[#3]

Hi,

Do you mean like this:

label your expression as:

=Concat({[State1]} DISTINCT Client, ', ') & ' Sales'

same for the 2nd expression but with [State2].

You can select more than 1 client, they'll be separated by commas.

Is that what you want ?

[#4]

I already used this option and  this is only a sample but in the main application there are number of client and then this option is not feasible there.. is there any other way to do

[morgankejerhag]

What do you mean by "there are number of client"?

Best regards,

Morgan Kejerhag

Senior Business Intelligence Consultant, Drake Analytics

http://www.drakeanalytics.se

[#6 · Accepted solution]

Maybe like this:

=if(Count({[State1]} DISTINCT Client) > 1, 'State1 Sales',

Only({[State1]} Client) & ' Sales'

)

When more than 1 possible client => State sales

otherwise specific client.