Customize the ‘Total’ in MicroStrategy

How to customize the Total, for those present in the report?

Here is solution:

After placing required attributes and metrics in to report, run the report and once you get data go to Data Menu –> sub Totals –> Advanced –> New — > Type ‘#A total’ then do the normal total selection (like subtotal by row, etc, etc).

Now, the total appear as ‘ Attributename Total’ for each total.

Some more tips on custom totals:

#A
The name of the attribute under which the subtotal appears.
#P
The name of the attribute to the left of, or above the attribute under which the subtotal appears.
#0
All the forms of the parent element.
#1
The first form of the parent element reading from left to right or from top to bottom.
#2
The second form of the parent element reading from left to right or from top to bottom.
#3
The third form of the parent element reading from left to right or from top to bottom.
#4
The fourth form of the parent element reading from left to right or from top to bottom.

Note: single Quotes to highlight, dont give the same in report :)

About Senthilraj

DW BI Architect and BI Project Management (Specialized in MicroStrategy). Hobbies/Passion about photography, tennis, music, travel-trekking. Website: www.b-diamonds.com www.facebook.com/SENRAJ81 www.linkedin.com/in/senraj


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399