Hi!
I am new to transformer. I have a requirement to create a cross tab report (see below). I created a dimension called Customer with levels customer accountName. Also created a dimesion Date and added a measure called Units Sold to the cube. Can anybody tell me how to achieve the result mentioned below. Thanks.
# of Accounts Jan 10 Feb 10
Accounts >=4 units 400 200
Accounts >= 8 units 232 142
Accounts >=12 units 15 800
What tool are you using to build the report? Poewrplay or Report Studio?
To get those elements into the rows they have to
1. Already exist in the cube (extremely impractical as you basically need every combination of month and grouping)
OR
2. Need to be built with an expression (can't be done in Powerplay but can be done in Report Studio)
Do you have much Report Studio experience?
If each individual account is a category in the cube then create a measure of type 'category count' against your account level