I have below scenario and I need to get/show only the total ratio (0.36%) and put in a gauge graph. However per using AVG function I only got 0.34%
When I removed the factorate column coverage amount and ratio column ended blank.
I need your help on this.
|factorate (dimension)||sum of net (measures)||coverage amount(factorate * sum of net )||PD amount(measures)||ratio (coverage amount / PD amount)*100|
There you go:
You can use conditional to determine the dimensionality for total and non-total columns and set your expression accordingly.
Qvw attached for reference.
Thanks and regards,
Kristel, did any of the posts help you get things resolved? If so, please consider using the Accept as Solution button on any of them that were of help to getting your working solution, as this will give those posters credit for the help, and it will also let other members know what actually worked for your use case.