Grand Total with dimension filtered

#1

Hi,
I have a pivot table with serveral Dimension on row.
When I set filter on a partucular dimension the grand total is not changed.
The grand total always considers all rows.

Why? Which can I filter in this case?

PS: I don't want put dimension filtered on a page filter of pivot table.

Thanks.

#2

Try to find somewhere in 'Commands an Options'
Report Options: (radio button)
Visible items only

"Dario Concilio [MCP]" <dco (AT) experta-spa (DOT) com> wrote

Quote:

Hi,
I have a pivot table with serveral Dimension on row.
When I set filter on a partucular dimension the grand total is not
changed.
The grand total always considers all rows.

Why? Which can I filter in this case?

PS: I don't want put dimension filtered on a page filter of pivot table.

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Grand Total with dimension filtered

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Grand Total with dimension filtered - 04-27-2005 , 10:14 AM

Re: Grand Total with dimension filtered - 04-28-2005 , 07:23 AM