Skip to Content
avatar image
Former Member

Crosstab Report unable to subtotal by Year. Currently Subtotal combines 2016 and 2017.

Hello,

I have a report that I need to calculate 2016 and 2017 QRec and @Cost separately. Only option is to caculate 2016 and 2017 together but I do not want that. Abhilash Kumar You the man.. Help.. :)

subtotal-2016.png (24.4 kB)
data.png (52.0 kB)
capture.png (28.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 09 at 04:28 AM

    Hi Daniel,

    What is the issue here?

    How do you want the totals to be calculated?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09 at 09:04 PM

    Hi Abhilash,

    I would like to have the Total QREC and @Cost to be by year. Currently when I subtotal the crosstab row data, it adds both years together.

    I would need 1 column for Total by 2016 and 1 column for total by 2017. A Difference column for the 2 years would be great as well. capture.png

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09 at 09:12 PM

    Abhilash,

    I attached a report that I have in excel. This is how I would like the data to be calculated. See the 2016 vs 2017 area...

    I cannot find a way to calculate 2016 and 2017 data separately. capture.png

    Add comment
    10|10000 characters needed characters exceeded