Sum for each column value in pie-chart

[razvan_brais]

Hy guys , I have a table in which I have this kind o data:

ID	Description	Sales
1	Laptops	50
1	Phones	130
1	Watches	40
2	Laptops	60
2	Phones	75
3	Laptops	30

I want to show in a pie chart values for a selected ID for each type of description.

I don`t want to use Description as a dimmension because I need to bring in this pie chart values from other tables .

Thank you

[Anil_Babu_Samineni]

Where is the other table,

ID - Dimension

Expression - Sum({<ID=, Description = {"*" - Aggr(GetFieldSelection(ID),Description)}>}Sales)

[susovan]

Is it your requirement?

[razvan_brais · Accepted solution]

Thanks a lot guys for your answers , but I have change a bit the aproach. I brought all my info in one table because I wanted to avoid all these calculation that could make my app work slowly.

[rupamjyotidas]

Its a good thing to close the discussion , once you have solved your problem. Thanks

[deepakqlikview_123]

Hi,

Create the composite key for first 2 col.

Use that as a dimension and put label as per ur naateed. Or cree extenal inline tble for showing associatons and name that as per req.

Thanks