ContributionsMost RecentNewest TopicsMost LikesSolutionsconditional formatting of subtotals and grandtotal In a pivot widget when you add conditional formatting it does NOT apply to any sub totals or grand totals included in the widget. It should apply to all relevant cells including the totals. dynamically sort pivot columns based on values Right now if I have a pivot table showing revenue and the rows have the customer name and the columns show the product name the product names will only appear in alphabetical order regardless of the revenue value of that product. The columns should be able to be sorted dynamically based on the value of the revenue or whatever metric is included. Re: Draw Total Line For A Stacked Column Or Bar Chart this works well when i have a dimension as my category but not with a date field as the category. Any idea on how to update it for time series? Re: Draw Total Line For A Stacked Column Or Bar Chart this is great. just what I was looking for. thanks!