Give label for Subtotal

[zam6ak]

Is it possible to give a label for the subtotals row?

In your example:
http://nagarajanchinnasamy.com/subtotal/examples/subtotal_pivot.html

if you expand on Gender, the top cell for Procince (subtotal) is blank.
It would be nice if it could automatically put in "Subtotal for Province"
Perhaps via config option or something....

[nagarajanchinnasamy]

@zam6ak If I am right, you are referring to the highlighted cell in the attached image.

Sure, we can add a title text instead of keeping it empty. I will take this as an enhancement.

Just one clarification though: That highlighted cell's row is the subtotal row for Female. Not for Province.

[zwirnerj]

@zam6ak maybe it helps if you just add:
table.pvtTable .pvtRowLabel {vertical-align: top;}
to your css file. After that the "female" label is on top next to the subtotal.
There are a lot of things that can be done to fit your needs just by adjustment of CSS:

[zam6ak]

@nagarajanchinnasamy You are correct, it is for Female. I think it would be nice to add this via config option and if enabled it would just put text "Totals for {{colOrRowName}}" Also, perhaps, this makes sense only when item is expanded?

@zwirnerj this is not the same as having a label....I do think this CSS should be default though. It helps a lot

[nagarajanchinnasamy]

Thanks @zwirnerj ... Nice idea :)

Along with what @zwirnerj has suggested, you can highlight the subtotal row with a different background color as shown in one of the examples. I think that will be more elegant without adding more text into the table.

@zam6ak I get your point too.... Please try above suggestions and let us know. Implementation wise it should not be very difficult to add what you are suggesting... but would like to hear from you after you have tried the options suggested. Thanks :)

[zam6ak]

@nagarajanchinnasamy I added the style that @zwirnerj suggested. It looks better, but I wish there was a way to change the background color of the subtotals row but only row when expanded.
I think that would ultimately do it.

[nagarajanchinnasamy]

Did you check this example at:

http://nagarajanchinnasamy.com/subtotal/examples/subtotal_pivot_css.html

Does that help?

[ilyaguy]

I've used following styles

            table.pvtTable .pvtRowLabel {vertical-align: top;}
            .pvtRowSubtotal.rowcol0, .pvtColSubtotal.colcol0 {
                background-color: #EFEFEF !important;
                font-size: 1.3em;
                font-weight:bold;
            }
            .pvtRowSubtotal.rowcol1, .pvtColSubtotal.colcol1 {
                background-color: #EFEFEF !important;
                font-size: 1.2em;
                font-weight:bold;
            }
            .pvtRowSubtotal.rowcol2, .pvtColSubtotal.colcol2 {
                background-color: #EFEFEF !important;
                font-size: 1.1em;
                font-weight:bold;
            }
            .pvtRowSubtotal {
                background-color: #EFEFEF !important;
                font-weight:bold;
            }

and result is:

[zam6ak]

@ilyaguy After applying your styles I realized that background color completely wipes out effects of Heatmap renderer....

[nagarajanchinnasamy]

@zam6ak hope styling collapsable labels #20 will be able to meet your requirement!!!???

[nagarajanchinnasamy]

Will take this forward with #20 styling collapsible labels. Closing this for now.