Analytics Software

Hi All,

I have the following Fact table

Brick___Sales
B1_____100
B2_____200

And following Helper table

TA__Brick__Province
0____B1___P1
0____B2___P2
1____B1___P1
1____B2___P1

This means a Brick can be a part of the same or different province for different TAs. e.g. For TA=0 and TA=1, B1 is a part of P1 but B2 is a part of both P1 and P2.

Now, I join the tables on Brick; create a report with Province and Sales and take TA as multiselect pompt. When I select TA as 0 or 1 in the prompt, the result is correct. But when I select both of them, it shows the result incorreclty as for P1 and B1 combination, the sale is added twice (when in fact this sale is done only once). So the problem is to show the Sales for a Province correctly by taking the Sale for a Brick only once when 2 or more TAs are selected at the same time.

Does anybody have any solution for this or provide me with some pointers?

Regards,
Roy.