How do I stop aggregation of keyfigures when the detail characteristic is removed from the query?
I have data as below:
-Project Project Invoice Number Bill No Proj Inv Amt
P1 P1INV1 B1 100
P1 P1INV1 B2 100
P1 P1INV2 B1 200
P1 P1INV2 B2 200
One invoice can have many bills associated to it. In the above case, if the user does not want to view the Bill No then the current output received from the Bex Query is :
Project Project Invoice Number Inv Amt
P1 P1INV1 200
P1 P1INV2 400
It should however show the values as 100 and 200 for the Invoices. I am able to achieve this in a Web Intelligence report on the query but using that is not an option.
Any ideas on how this can be achieved?