How to show a temporary value in a custom sort?

system · July 9, 2011, 2:40am

Hi experts,
I want to insert a 13th month for adjustment purpose in the month name column. But it doesn’t show on report even though it was added into custom sort. I cannot understand some old answers for this question.
Variable can make it. Do you mind give me more details? How to create this variable? How to force the 13month show after 12 months? Thanks.

tigerni2005 (BOB member since 2011-07-09)

system · July 9, 2011, 4:57am

Create an object in the universe and write a custom SQL using UNION to add the 13th month and use that in the report.

BO_Chief (BOB member since 2004-06-06)

system · July 10, 2011, 2:50am

BO_Chief, thx. I will try it.

tigerni2005 (BOB member since 2011-07-09)