transformer model to display total # of accounts with specific units sold

[zverma]

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      

[nmcdermaid]

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?

[nmcdermaid]

If each individual account is a category in the cube then create a measure of type 'category count' against your account level