Skip to Content
0

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

Feb 08 at 11:05 PM

46

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abhilash Kumar
Feb 09 at 04:28 AM
0

Hi Daniel,

What is the issue here?

How do you want the totals to be calculated?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 09 at 09:04 PM
0

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


capture.png (40.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 09 at 09:12 PM
0

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


capture.png (74.6 kB)
Share
10 |10000 characters needed characters left characters exceeded