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?
I think you can use the pivot from the charts.
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.
Thanks so much!
post your data source
Definitely you can use Pivot Chart here due to your requirement.
use pivot table. It will take care of the format.
Retrieving data ...