Hi,
is it really not possible to group by a members property in a crosstab???
For example a fact table with sales. A dimension table with salespersons with gender as attribute. Now in a report I want to show sales by gender in a crosstab. Doesn't seem to work...
Do I really have to add the gender information into the fact table?
Thansk in advance,
Florian
Pl be clear.... if you create any expression either filter or query calculation automatically it ll be in query.
If you want to refer other query in current query..you can use it , but in query make it as Cross product allowed.
I think we talk about two completely different things.
For my little example i want to build a report with sales data.
But I don't want one row for each salesperson, I want two rows, one for male, one for female, with the respective facts summed up.
The gender of the salesperson is a member property of the salesperson member.
Quote from: florian on 12 Oct 2015 07:41:34 AM
I think we talk about two completely different things.
For my little example i want to build a report with sales data.
But I don't want one row for each salesperson, I want two rows, one for male, one for female, with the respective facts summed up.
The gender of the salesperson is a member property of the salesperson member.
Is this a dimensional or a relational package? As you refer to Member I'm assuming dimensional? If so, you'd need to have Gender as a level in the hierarchy above Salesperson to get what you need (so you have Gender members for Make and Female). If it's a relational package, you simply need to bring in the Gender query item into the rows area.
MF.
That's a good idea, Thanks!
I'm working on a similar problem, but I want Gender to be the Columns not the rows. Do I need to create extra query items of something? I think that as a crosstab I shouldn't have to count the genders separately if I'm not mistaken.