Traditional web-based reporting with SAS BI tools

subtotal of column in web report sudio

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

subtotal of column in web report sudio

i want column subtotal in web report sudio,i use subtotal of column,but report generate all column subtotal,

but i want only perticular column subtotal

so how it solve problem

attached file contain data ,

i dont want subtotal of 'product'

except product i want all column subtotal

so how we can skip that variable (product)?

Untitled.png


Accepted Solutions
Solution
‎05-06-2015 09:36 AM
SAS Super FREQ
Posts: 381

Re: subtotal of column in web report sudio

Beginning with release 4.4, you can exclude selected measures from totals. However, there is no way to exclude a category from a total. In other words, you cannot see a  total for "No. of Cases" for "Status" and "Branch" but not for "Product". You could only exclude totals completely for "No. of Cases." This is what the option looks like.
wrs_totals.jpg

View solution in original post


All Replies
Solution
‎05-06-2015 09:36 AM
SAS Super FREQ
Posts: 381

Re: subtotal of column in web report sudio

Beginning with release 4.4, you can exclude selected measures from totals. However, there is no way to exclude a category from a total. In other words, you cannot see a  total for "No. of Cases" for "Status" and "Branch" but not for "Product". You could only exclude totals completely for "No. of Cases." This is what the option looks like.
wrs_totals.jpg

Contributor
Posts: 24

Re: subtotal of column in web report sudio

you give that solution is work for version 4.4

i have web report studio version 4.31

please give me other solution for version 4.3 if you have

thanks.

SAS Super FREQ
Posts: 381

Re: subtotal of column in web report sudio

I'm sorry but hiding totals for selected measures was a feature added in 4.4

Contributor
Posts: 24

Re: subtotal of column in web report sudio

how we provide conditional highlighting on total and subtotal?

so using conditional highlighting we put black color on 'product' subtotal , so it can hide / not visible.

SAS Super FREQ
Posts: 381

Re: subtotal of column in web report sudio


Unfortunately, SAS Web Report Studio does not apply conditional highlighting to totals and subtotals. This is one of the SASware ballot ideas that you can vote on: https://communities.sas.com/ideas/1140

Post a Question
Discussion Stats
  • 5 replies
  • 805 views
  • 1 like
  • 2 in conversation