on 09-01-2014 1:27 PM
Hi experts!
I'm using excel addin version 10.0 SP07 Patch 02 .NET4 Build 7222
I have on report that on rows has an item dimension and customer dimension.
So I can see rows like this:
ITEM1---CUSTOMER1:50
ITEM1---CUSTOMER2:100
ITEM1---CUSTOMER3:25
ITEM2---CUSTOMER1:30
ITEM2---CUSTOMER3:30
ITEM3---CUSTOMER1:50
ITEM3---CUSTOMER4:50
ITEM3---CUSTOMER6:100
I need two total in this report.
My first Total is using FAMILY Property.
ITEM 1 and ITEM 2 belongs to FAMILY 1 and ITEM3 belongs to FAMILY 2
So I can use Member Sorting and Groupind editing my report
=SUBTOTAL(9,EPM_SAME_PROPERTY(ITEM,FAMILY))
So my result is fine:
FAMILY1------------------------235
ITEM1---CUSTOMER1:50
ITEM1---CUSTOMER2:100
ITEM1---CUSTOMER3:25
ITEM2---CUSTOMER1:30
ITEM2---CUSTOMER3:30
FAMILY2-------------------------200
ITEM3---CUSTOMER1:50
ITEM3---CUSTOMER4:50
ITEM3---CUSTOMER6:100
My problem is that I have to add another subtotal:
I need a new subtotal by ITEMS but I don't know how to add another group editing report.
Result of my report should be:
FAMILY1------------------------235
ITEM1TOTAL------------------175
ITEM1---CUSTOMER1:50
ITEM1---CUSTOMER2:100
ITEM1---CUSTOMER3:25
ITEM2TOTAL-------------------60
ITEM2---CUSTOMER1:30
ITEM2---CUSTOMER3:30
FAMILY2-------------------------200
ITEM3TOTAL-------------------200
ITEM3---CUSTOMER1:50
ITEM3---CUSTOMER4:50
ITEM3---CUSTOMER6:100
Any help with this problem?
Thanks!!!
Hi Alex,
In general, aggregating by properties is not a perfect idea, please use hierarchy or multiple hierarchies. It's the main idea of cubes...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good Morning Experts!
A few time ago, I had the same problem and I couldn't solve it. I had a report that the rows was displayed by "EPMDIMENSIONOVERRIDE", so I couldn't use the dimension structure. I needed more than a SUM by rows to make subtotals but I only could made once, using "Member Sorting&Grouping".
In these, you can introduce a subtotal using the best property of the dimension for your report, but I think that it only allows one.
If someone knows a way to display more than one subtotal by rows, it will be very usefull for us!
Thanks and good luck Alex!
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.