very very important....how to add a row in pivot table

[#1]

hi

i am creating a pivot table in which i am taking a column from database as row. from database i am getting six different rows but i want to add 2 more rows showing the total of these 8 rows and their count.

how can i do that.....plz help me

[subin6600]

Hi Vitul

Could you explain it with some examples for trying to get a solution for it?

Regards,

Subin

[Anonymous]

Doesn't checking the checkbox Show Partial Sums on the presentation tab get the result you want?

Check it for all the dimensions you want to see a total.

[Anonymous]

You could concatenate the additional 2 rows of data you need in your script - so they will then appear in your chart.

[#5]

http://community.qlik.com/ideas/1950

[#6]

Is there a reason you down voted this idea?

It would do what they are looking for where they could use a unique expression to add another total so they can count and sum.

[Anonymous]

kludgy UI. I didn't realize that was a down vote action.

On Fri, Apr 27, 2012 at 3:33 PM, marcsliving <

[#8]

hi All

in my situation i am using 1 dimension and the data for that dimension i scoming from database....

and on the basis of that dimension i am calculating values for the columns. now i want to add a row which is showing the total of all the rows coming from the database and one showing the total....

regards

Vitul