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 |