Sub Totals in Excel Pivot - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Sub Totals in Excel Pivot

Author

Topic

LuckyJim
Starting Member

9 Posts

Posted - 2010-07-19 : 05:49:52

Hi all,

Trying to find out if this is possible.

Excel 2002 connecting to an OLAP cube on SSAS 2005

I have a dimension called Revenue Group that has 3 members. They simply relate to a field that holds sale data

So it looks like this

Revenue Group TY-Sales Revenue NET VAT
Sale - Orig. Price 410
Sale – Discount ( 36)
Full Price 10

For each shop there are product groups so it looks like this

Procurement Group Revenue Group TY-Sales Revenue NET VAT
PERFUME Sale - Orig. Price 1
Sale - Discount 2
PERFUME Total 3
LADIES DESIGNERS Full Price 1
Sale - Orig. Price 2
Sale - Discount 3
LADIES DESIGNERS Total 7
LADIES DESIGNERS ACCESSORIES Full Price 1
Sale - Orig. Price 2
Sale - Discount 3
LADIES DESIGNERS ACCESSORIES Total 7
LADIES PRODUCTION Full Price 1
Sale - Orig. Price 2
Sale - Discount 3
LADIES PRODUCTION Total 7

Here’s the rub. The boss wants to see totals for each shop.

So I need to add rows to the shop totals like this

Shop 1
Sale - Orig Price Total for shop here
Sale - Discount Total for shop here
Full Price Total for shop here
Grand Total 10

Does that make sense ? I have tried turning on sub totals but that does not give me the grand totals I need. It just subs the individual Procurement groups

Any ideas ?

Thanks all.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources