I need to build an Stacked Bar Chart where all bars sum 100%.
One dimention is Country and the other one is Type and the expresion its a count of Program.
The problem is with the denominator for the percentage because a program can be repeated for the same country and type since it can have different products
I tried with
COUNT (TOTAL <Country> Program)
AGGR(nodistinct COUNT(Program), Country)
I attached the qvf and the excel with the graph that should be shown.
Thanks in advanced.