Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you can select only one option i hope either total or count
Hi Rahul
create another chart for count with same dimensions and put it under that .
Sam
Hi gautik92
Thanks for your quick response, unfortunately I need both the fields sum as well as count.
Hi Sam,
but I need it in single Object and that too in tabular format.
not possible
Is there any alternative, suppose v can do anything in back end to achieve this
Unfortunately it is not possible
i hope you can create another chart
allign it properly bottom of first chart.
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.