topic Re: subtotal of column in web report sudio in SAS Web Report Studio

subtotal of column in web report sudio

dipakgopale — Wed, 06 May 2015 10:39:46 GMT

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

Re: subtotal of column in web report sudio

Madelyn_SAS — Wed, 06 May 2015 13:36:18 GMT

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.

Re: subtotal of column in web report sudio

dipakgopale — Thu, 07 May 2015 09:19:33 GMT

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.

Re: subtotal of column in web report sudio

dipakgopale — Thu, 07 May 2015 09:26:50 GMT

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.

Re: subtotal of column in web report sudio

Madelyn_SAS — Thu, 07 May 2015 13:53:55 GMT

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

Re: subtotal of column in web report sudio

Madelyn_SAS — Thu, 07 May 2015 15:47:21 GMT

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