Hello,
I have the followinf fact table:
Question | RespondentId | Answer | % of GT of RespondentId |
What's your name | 39 | Dana | 9% |
What's your name | 69 | Juliet | 9% |
What's your name | 71 | Lorelai | 9% |
What's your name | 31 | Caden | 9% |
What's your name | 57 | Imani | 9% |
What's your name | 38 | Adrien | 18% |
What's your name | 68 | Valentin | 18% |
What's your name | 81 | Dale | 36% |
What's your name | 53 | Dale | 36% |
What's your name | 16 | Dale | 36% |
What's your name | 64 | Dale | 36% |
What's your favorite city | 39 | Lora del Río | 9% |
What's your favorite city | 69 | Marchena | 9% |
What's your favorite city | 71 | Moron de la Frontera | 9% |
What's your favorite city | 31 | Barcelona | 9% |
What's your favorite city | 57 | Madrid | 9% |
What's your favorite city | 38 | Did not answer | 18% |
What's your favorite city | 68 | Did not answer | 18% |
What's your favorite city | 81 | Huesca | 36% |
What's your favorite city | 53 | Huesca | 36% |
What's your favorite city | 16 | Huesca | 36% |
What's your favorite city | 64 | Huesca | 36% |
Now I want to add a custom column [% of GT of RespondentId], however I need that to take into account Question value.
In a report view I use a table that shows [Answers] and Count of [RespondentId], as well as [% of GT of RespondentId], in addition to using Filter's pane on the whole page for [Question]. Every page shows different questions and thus has an active page level filter.
Thanks for help!
Solved! Go to Solution.
Hi, @Dom87326 ;
I don't quite understand your logic, how did you calculate % of GT of RespondentId? What kind of logic implements this formula for 9% and 18% and 36%?
I tested it as follows:
so can you share more information or your logic?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Dom87326 ;
I don't quite understand your logic, how did you calculate % of GT of RespondentId? What kind of logic implements this formula for 9% and 18% and 36%?
I tested it as follows:
so can you share more information or your logic?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!