Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try using Inter-Record Functions to bring them on the same line. You might need Above/Below based on your sorting.
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.