subtotal of column in web report sudio

[dipakgopale]

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

[Madelyn_SAS · Accepted solution]

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.

[dipakgopale]

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.

[Madelyn_SAS]

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

[dipakgopale]

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.

[Madelyn_SAS]

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