5 Replies Latest reply on Jun 3, 2015 11:03 AM by Manish Baid

# whether to make subtotal row dynamic by displaying variable name.

Hi,

When i am doing subtotal, it is just displaying total in the bottom of each value of variable and the revenue data.

I want display the name of variable which will be dynamic.I think it is a basic function, but unable to find solution.

ex. Lets we have country,states and sales.

In the subtoal it should show state name and sales.

now    total      1million

expected california  1 million

albama    2 million

Thanks,

Ranjan

• ###### 1. Re: whether to make subtotal row dynamic by displaying variable name.

Hi Ranjan,

I'm not sure I completely understand the request. Does Alabama have 2 million in Sales or do they have 1 million and since California has 1 million, it now has a total of 2 million? If the latter is the case, a running total table calculation can be used.

-Tracy

• ###### 2. Re: whether to make subtotal row dynamic by displaying variable name.

Hi Tracy,

T

My question was not with data of revenue, but with the dimension against which the subtotal is calculated.

Lets sat data

region   state   sales

east     Georgia  100

east     florida     150

north    illionis     50

north    montao     75

if i do subtotal  against region

data should be

east     Georgia  100

east     florida     150

Total(east)           250

north    illionis     50

north    montao     75

Total(north)            125

But it is only displaying Total  250,not total(north), a variable should be put.

Thanks,

Ranjan

• ###### 3. Re: whether to make subtotal row dynamic by displaying variable name.

Dear Ranjan,

I believe what you are looking for is to add the Region Name to the 'Total' label on Sub-Totals. Is that correct? I don't think it is possible to edit the label to show the Region Name here. As Tracy mentioned, it is possible to add a Table Calculation to achieve this.

I have attached a sample. Is this what you were looking for?

Cheers

Siraj

• ###### 4. Re: whether to make subtotal row dynamic by displaying variable name.

Hi Siraj,

Thanks for your reply. The interface i am looking for is subtotal should be in row. You tried to calculate in columns.

If it is not possible to display, i think its fine. I was just looking of the solution as total should be displayed as

total(&variable), which will be more clear and will avoid confusion when there is large amount of data.

Thanks,

Ranjan

• ###### 5. Re: whether to make subtotal row dynamic by displaying variable name.

Hi Ranjan,

I know it's been long you have posted the query. Could you please share your proposed solution if you have gotten to anything substantial. My requirement is exactly the same now and i am struggling to make the sub total labels dynamic.