budLL
Well Known Member
Hi List,
There is one report customer asked for which is a budget YTD report. It will show 12 periods as column, and each business unit as row.
I picked up the FINRPTPA - Period Activity as my smart fileds using 12 times in the report. And for each row I selected the business units user asked. But it didn't work as what I want. It shows a lot of data, I even don't know where they came from.
I think the report is showing by account instead of by business unit. In column report, I can use level break to get the total for each business unit. but how can I do that in a row report? Which smart field should I use?
Thank you very much for any help.
Bud
There is one report customer asked for which is a budget YTD report. It will show 12 periods as column, and each business unit as row.
I picked up the FINRPTPA - Period Activity as my smart fileds using 12 times in the report. And for each row I selected the business units user asked. But it didn't work as what I want. It shows a lot of data, I even don't know where they came from.
I think the report is showing by account instead of by business unit. In column report, I can use level break to get the total for each business unit. but how can I do that in a row report? Which smart field should I use?
Thank you very much for any help.
Bud