Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to create a table like this. The main question is about the column 'Group' and 'Name' which are the dimension. How to do that?
Group | Name | Sale percentile | Sales |
---|---|---|---|
Group 1 | Tom | 10% | 1 |
Lily | 30% | 3 | |
Group 2 | Jon | 20% | 2 |
Group 3 | Will | 40% | 4 |
Thanks.
Jelly
I think you can use the pivot from the charts.
I think you can use the pivot from the charts.
hi
post your data source
Hi,
Definitely you can use Pivot Chart here due to your requirement.
Regards
Anand
Hi,
Yes the pivot table is useful. And how could I remove the plus sign from the table so that it will not show in report?
On the Presentation Pane, check "Always full expanded". That will remove the +/- icons.
-Rob
Hi,
use pivot table. It will take care of the format.
Thanks so much!