Selection steps impacting grand total

chris.du

Hi all,

I have a problem, not sure if it's a misunderstanding of selection steps or an error in my repository.

In my repository I have a dimension for company and a fact table with employees.

In my analysis I have the column for company from the dimension and the column for the number of employees within a company with a grand total. Everything shows fine.

company	# of emp
1	10
2	25
3	5
4	100
Grand Total	140

Now I have added selection steps for the company based on a prompt (selection list) starting with all elements.

When I open this analysis everything shows fine, all companys and grand total over all of them. When I select a company from my prompt, only this company is shown in analyses - that's like expected - ,but also the grand total is now calculated only for this selected company - so I expected the grand total calculated over all companys.

company	# of emp
1	10
Grand Total	10

Everything I read about selection steps, was, that it is not impacting the grand total. Every thread I found here, was telling me that it is not impacting the grand total ... But in my case it does and I don't want this.

I want to "filter" my companies and having my grand total still be shown over all companies. So in the example I expect the grand total still showing 140.

Can anyone please give me a hint, what to do to get this working?

Thanks

chris