Dear All,
Is it possible to have different types of aggregations for individual columns ? As showed below I need to have only the subtotal for year 1996-1997 (GRP 1) and not for 1998 (GRP 2).
Wich is the technical solution (or trick) to apply in order to solve this issue?
In attached is reported the twbx file, any help is apreciated
Best regards,
MJ
Dear all,
As reported in another topic (https://community.tableau.com/update-advanced-comment.jspa?id=934625&draftID=760764 ) I have tried to create a individual calculation for each column, but unfortunately doesn't work. As we can see the year are disalined:
In attached is reported the "Custom_columns_Subtotal v2.twbx" file with this issue (please refer to sheet 2).
Best regards,
MJ
Michael,
You need to extract your data before saving as .twbx.
If we open your workbook it is currently trying to connect to your server.
Based on the solution provided on your earlier post, gave it a try, please see if this what you are looking for
Thanks
Madhuri
Dear Michel,
in attached the Dashboard saved using extraced mode.
Thanks,
MJ
Michael,
If you download the file from the other post you mentionned. (conditional formatting v4.)
Check the Sheet Crosstab of Many Colors.
The goal is to create axes and put them on the column shelf. Each axis have its own set of property shelf, so you can put each measure values on the Label shelf of each axis.
This implies that you need to make one calculation for each year + one for the group1 total.
In the attached , you have a quick start. You can check with the example in the conditional formatting file, it shows how to get the header on top by using dual axis, and other possibilities you can achieve using dual axis.
Based off of the workbook provided by MICHEL CAISSIE , worked on the following attached workbook
Thanks
Madhuri
Dear MADHURI.TANNIRU and MICHE,
It works!
Thanks a lot your feedback is very appreciated.
Best regards,
MJ