Is there a way to show a measure only once when we have repeating dimension values?
We have a scenario where an insurance policy has multiple drivers. However, there is only one insurance premium at the policy level. If we add drivers to a discovery with a measure it replicates the measure and then totals to a wrong number. Here is sample data:
Policy Table
Drivers Table
These two tables join by the Policy ID field.
When I create a discovery I get the following. Is there a trick to have the $12,001 show once or have the total reflect the policy level value of 12,001 instead of summing it five times, getting the wrong value of $60,005.00?
Thanks,
Rob Clark
1 reply
-
Hi Robert Clark,
Instead of using the grand total, you can use the subtotal along with the average. This approach will help in analyzing multiple policy details.
Hope its help you.
Thanks,
Vijayan Krishnan