FSG need assistance
Hello Expert!
I have to create an FSG the columns amount type should be YTD ( by month) for all lines in the Row set except for one row set that the amount should be PTD.
How can i do that?
i go to the disered row set , and i modify the amount type to PTD , but the reuslt is that i have the same amount for the current month in all the culumns of the FSG.
This is an example of the needs
JAN-20 (YTD) | FEB-20 (YTD) | ……..DEC-20 (YTD) | ||
ROW1 | YTD AMOUNT | YTD AMOUNT | YTD AMOUNT | |
ROW2 | PTD AMOUNT | PTD AMOUNT |