Selection from a chart does not work as expected

[dafnis14]

Hi,

I've created a table which consists of items which i flagged as Total or Item.

I grouped them with a Category code.

The two charts are supposed to be linked. So if i select a bar which represents Total  on the left,

I would see the linked items on the right.

It works only if I select a category:

Selecting a bar from the left does not display the linekd items:

Attached is a demo model.

Could someone assist me in finding the reason?

Thanks!

[sunny_talwar · Accepted solution]

Not sure what you are looking to get, but may be this for sub level chart

sum({< Income_Flag_Item ={1}, Income_Desc, Income_Categ_Code = p(Income_Categ_Code)>} Income_Total_Amount)

[dafnis14]

Dear Sunny,

I just thought of it myself after taking a break.. 🙂

You are absolutely right...!

Thanks!