Getting results into the same line

[burgersurfer]

Hi, I am using set analysis to produce a table, wherein we want to compare transactions for this year, with the same period last year. My current model does not allow me to show them next to each other - I am only able to show this year's figure in one line, and the previous year below it.

How can I get the results aligned?

Attached is a screenshot of the table extracted to Excel, I need the green cells to line up in QV?

Thanks so much!

Corne

[sunny_talwar]

May be try using Inter-Record Functions to bring them on the same line. You might need Above/Below based on your sorting.

[vamsee]

You are classifying your data twice. Remove either your dimensions which are specific to a year like UPT 2019 or use one expression for both the year's.