Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a straight table. I have some aggregated data like total days, average days, total margin, average margin etc etc. I have grouped every same relevant expression like avarege margin, total margin is one group, average days, total days is another group etc etc. There is no dimension in the chart. Is it possible that if I select average days, all of the other groups show the average expression. IfI select total margin, the rest of groups in chart should show total days, total charges etc etc. I have to do it without storing this in a seperate table with one column showing whether average or total and the second column having valeus.
Can someone guide me please. If you need some info..I will provide more detail.
Regards
Arif
This can be achieved by a macro triggered on the OnAnySelect event. Not recommended though. If you could post a sample application, maybe there is a workaround.
Look at this sample.
Have fun
MC