×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Selected Subtotals in Page-by

Selected Subtotals in Page-by

Selected Subtotals in Page-by

(OP)
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...

RE: Selected Subtotals in Page-by

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

RE: Selected Subtotals in Page-by

(OP)
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!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close