Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have a table data like this:
ID | Description | Amount |
---|---|---|
11111 | AAA | 30 |
22222 | AAA | 40 |
33333 | BBB | 20 |
44444 | CCC | 10 |
55555 | CCC | 50 |
55555 | CCC | 60 |
22222 | AAA | 10 |
I need to sum the field "Amount" by "ID", but in my chart I'd like to show the corrispondent value of the field "Description".
I need an output like this:
Description | AMOUNT |
---|---|
AAA | 30 |
AAA | 50 |
BBB | 20 |
CCC | 10 |
CCC | 110 |
How can I obtain this output?
Create a straight table with ID and Description as dimensions and sum(Amount) as expression. Then on the presentation tab choose the ID column and choose the option Hide Column.
Hi,
PFA
In the presentation tab you can hide the column.
HTH
Sushil