Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selected Subtotals in Page-by

Status
Not open for further replies.

omarmtz

Programmer
Nov 22, 2002
75
MX
I need to put subtotals not to all the attibutes in my reports that are in the page-by; i use the Subtotal Advanced Option, and Across Level, but it's a selected subtotal, when i put total in one attibute, the second one always put total too, i don't want this, i would like to use like the all subtotal, but only the attibutes that i want...

thanks...
 
Hi there, I think you won't be able to use the subtotal function for this one. You could create a CONSOLIDATION containing the attribute elements and the totals affecting just those attributes. For example, if your attribute elements are:
Attribute
A
B
C
D

you could create a CONSOLIDATION such as:

Consolidation
A
B
A+B
C
A+B-C
D

Hope this helps,
Alfredo
 
Thanks, Alfredo... but the A, B, C and D, that you mentioned, are attribute' elements??... the report that i want is this:
The following attibutes in the page-by of my report...
______________________________________________
Concept Country State Products
______________________________________________
Ant other Attributes in the report area.

The problem, that i have, is that i want totals in the Country, State and Products Attributes only, not in the Concept. And when i use the Advanced Option of Totals, and i use Across Level for the Country, State and Products attributes, it works, but when i run the report, and i select Total in Country, the State and Products Attributes put Totals, too, and i don't want to choose Total for Products...

Help!!

This is a restriction on MicroStrategy??¡?¡

Thanks!!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top