Sum and Count at the bottom of the same table.

[rahulsud007]

Dear all

I have requirement in which I need count of items and sum of items in the bottom row as mentioned in the image in a straight or pivot table.

But in Single object not in multiple objects.

Please suggest me.

[gautik92]

you can  select only one option i hope either total or count

[mightyqlikers]

Hi Rahul

create another chart for count with same dimensions and put it under that .

Sam

[rahulsud007]

Hi gautik92

Thanks for your quick response,  unfortunately I need both the fields sum as well as count.

[rahulsud007]

Hi Sam,

but I need it in single Object and that too in tabular format.

[gautik92]

not possible

[rahulsud007]

Is there any alternative, suppose v can do anything in back end to achieve this

[gautik92]

Unfortunately it is not possible

[mightyqlikers]

i hope you can create another chart

allign it properly bottom of first chart.    

[kuczynska]

I think you can try to create (let's call it this way) "synthetic dimension". So field call "Total" in your load script. You can make it look like a default Total row by changing the Text format options in both dimensions and expressions.

The way I prefer is to concatenate a template table with 0 values as all of the dimensions. Have a look at the QVW, maybe it will be of any use to you.