Friday, February 13, 2009

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 :)

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.