Sales A B C D P1(A+B+C+D) A1 B1 C1 D1 P2(A1+B1+C1+D1)
Customer1 25 25 25 25 100 40 10 40 10 100
Customer2 25 25 25 25 100 25 25 25 25 100
Expected:
Sales A B C D P1(A+B+C+D) A1 B1 C1 D1 P2(A1+B1+C1+D1)
Customer1 25% 25% 25% 25% 100% 40% 10% 40% 10% 100%
Customer2 25% 25% 25% 25% 100% 25% 25% 25% 25% 100%
I wanted to show % of total for each product p1,p2
Iam using a calculated measure and my expression would be Sales/total(Sales with in set)
Here I have two sets one for product 1 -P1 and other for product2 -P2.
How will my expression be.
I have children(p1) as a member set and children(p2) as amember set in my query
How should I expression in my measure be...sales/ total(sales within set ????) allows only one set.
Any help is appreciated.
Thanks,
It's a little hard to tell from your example what I'm seeing. Are the (A,B,C,D) set and the (A1,B1,C1,D1) set from the same hierarchy? Are P1 and P2 siblings?
Yes. Two different sets from same hierarchy and my columns will have set 1 and set 2 and I should show the percentage total of the customer with respect to each set .
P1 is the total of a,b,c,d and p2 is the total of a1,b1,c1,d1..p1and p2 are parents .I want to show the percentage of sales with respect to p1 for a,b,c,d and percentage of sales with respect to p2 for a1,b1,c1,d1...
seems pretty straightforward... have you tried to start creating the report? what have you got so far? and where are you encountering a problem?
Sales/total(sales with in set p1) allows me to give only one set...how to get the percentage with respect to p2..
This worked.
Thanks Paul.
[Sales]/tuple([Sales],parent(currentMember(product Hierarchy)))