You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I use the table filter and charts add-on. I need to do three things:
Steps 1 and 2 are easy using a pivot table and table filter. To calculate the proportion I can use a table transform. However if I wrap a table transform around ta pivot table or filter they are essentially ignored. I tried using a table excerpt so that I can wrap a table excerpt include with a table transform to calculate the proportion but that doesn't work either. Any suggestions?
Hi @soumaya mauthoor ,
As you didn't provide any screenshots, I tried to recreate your case with a simple table.
In the first variant I used the Chart from Table macro to visualize the proportion of your categories:
Here is the pivot where I aggregate the data:
Here is the Table Filter macro where I continue to work only with the Android and Apple categories:
And, finally, the Chart from Table macro allows me to visualize the proportion easily:
For the second variant I chose your option and used the Table Transformer macro instead of the Chart from Table macro:
The first steps are the same, so here are the Table Transformer macro settings:
SELECT T1.'Android', T1.'Apple',
T1.'Android'*100/T1.'Total' AS '%Android',
T1.'Apple'*100/T1.'Total' AS '%Apple'
Hope this helps your case.
If you still have any questions, please, attach your screenshots here or raise a support ticket.