Format a Single Subtotal Cell - MicroStrategy


Yes, you can format a single subtotal cell differently than other subtotal cell in MicroStrategy. Let's walk through an example - skip to the bottom for the video version.


Let's take a look at the dossier below. I want to add custom formatting to a single subtotal cell of unit price. There isn't a direct way for me to apply the formatting to this single cell, but I can work around it by applying a threshold.




Next, set the threshold to apply to any values which are Null OR Not Null. This will ensure that this threshold will always be applied regardless of the value.



Next, add your formatting as needed.



Then apply this formatting only to the subtotals.


Now see your changes!



Or watch the video




Thanks for checking out this blog post. If you found this post helpful please consider donating via PayPal. Any contribution is appreciated!



212 views
  • LinkedIn Social Icon
  • Twitter Social Icon
  • MicroStrategy_Icon
  • paypal-square-social-media-512