Hi,
In my dashboard I have a bar chart with drill down dimension and two measures.
Dimensions are- segment IP+Division IP+BU IP+TC IP
And measures are
IP mapped- sum({<bkey_account=-{'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])
IP Not mapped- sum({<bkey_account={'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])
Segment IP's are-
DE Science |
DE Medical |
DE Paed |
For BD Science Segment IP, I am getting correct values for all the division IP's in graph, but for other segments values are repeating for all the Diviosion's IP .
Please suggest.