True Subtotals 
Author Message
 True Subtotals
I have a cube on AS2000 with production data, another with s{*filter*}data, and a
virtual cube that joins the two.  Users create pivot tables with Excel 2000
to create reports.  But if they filter out values, the subtotals and totals
are still calculated based on the global data.  What do I need to do so they
get true subtotals and totals for only the displayed data?


Tue, 09 Dec 2003 05:06:26 GMT
 [ 1 post ] 

 Relevant Pages 

1. SQL*Loader with Direct=true Parallel=true gives error

2. SQL Server True vs Access True...

3. How to get finer control of subtotals when summarizing Data Using ROLLUP?This query generates a subtotal report:

4. Subtotals

5. Hiding Subtotals on Pivot Table

6. Subtotal in SQL Server-OLAP-Pivot tabel

7. Invalid subtotals

8. Subtotals including regular data

9. MDX - subtotal w. CROSSJOIN

10. Subtotals in MS Excel using PivotTable (OLAP)

11. Removing Subtotals

12. SubTotal And Grand Total

Powered by phpBB® Forum Software