Creating relation between expression and new column

[manu1512]

Hi all,

I have very complicated requirement.I have to link expression in bar chart RR1 ,RR2,RR3 with newly excel data column MAASP[bar].

Please find the snapshot and data and please help me .

Regards

Manu

[Digvijay_Singh]

Can you share expected output, difficult to understand what do you need exactly.

[manu1512]

Hi Digvijay ,

RR1 RR2 RR3 are expressions in chart while in excel sheet they have corresponding  MAASP bar values in excel sheet .In bar chart we want to show MASSP BAR values to corresponding RR1 RR2 RR3 values.

Regards

Manu

[Digvijay_Singh]

Not sure but, something like this in RR1,RR2..expressions -

1. RR1 - Sum({<Ringraum = {'RR1'}>}MAASP)

similarly for RR2, and RR3

Not sure if Other category Bohrung has any significance here or not.

[manu1512]

Hi Digvijay,

Bohrung has very huge significance as every bohrung has correspondingRR1/RR2/RR3 and every RR1/RR2/RR3 for Bohrung has Maasp values.

Regards

MANU

[Digvijay_Singh]

Yes, so Bohrung is your bar chart dimension?

[manu1512]

No Bohrung will be used as key filter.

[manu1512]

stalwar1‌kaushik.solanki‌

[sunny_talwar]

You have created this chart (image above) using the three fields that you provided in the sample? 1) I am not sure if I be able to replicate the chart and if I did how much time would I be spending to replicate it ... 2) I am not really sure what is that you are looking to fix... can you make my life easier by creating a dashboard with the data loaded and the chart created in a sample qvw and then letting us know what is the problem that you are trying to fix

[manu1512]

Hi all thanks for help, by just doing minor change in data source i got my answer.

Thanks for your help

Regards

Manu