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

Grand Totals - Only For Certain Columns ??

Grand Totals - Only For Certain Columns ??

Grand Totals - Only For Certain Columns ??

Is it possible to show grand totals on only some of the columns instead of all of them?  I have some date columns where and percentage columns where Microstrategy is actually computing a total or showing 0.

Thanks -- We are still in our trial phase with this tool so I am VERY new.

RE: Grand Totals - Only For Certain Columns ??

yes.  you have 2 options.  

- for numeric columns or calculations (also known as simple metrics), when you edit the metric there is a "subtotal" tab that you can edit.  Here you just specify that the metric has no applicable subtotal.

- for the percentage columns (also known as compound metrics in MSTR), you can do the same as above and hide the subtotal.  Or you can turn on "Smart totaling" with a checkbox in the same tab.  This allows the percentage to be calculated from the component subtotals instead of adding up the percentages.

good luck with your eval.  I hope you can "break" the system with the most complicated report you need to build.

RE: Grand Totals - Only For Certain Columns ??

In addition to the "smart totalling" feature to handle "special" cases (%, % to total,....) you might have to use the evaluation order (Data - Report Data Options - Evaluation Order) to make sure the total/metrics/custom groups/consolidation are calculated in the right order.

To answer your question a little bit more directly, you can create a "custom subtotal" in your report that will not display the total for all the columns (click on "advanced/modify" when viewing the subtotal window).

2 cents,

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