Hi,
We want to know how to show only total columns using Rows & columns function from top left of screen.
Table data have budget and actual. Green cell is actual, the white one is budget.
When we use Rows & columns function for table of half year or quarter, the total value shows wrong.
Specifically, when data has one type (i.e. only budget or actual),it shows correct. However, including several data(budget and actual) shows only budget data.
Could you help me solve this?
Please see the attached file for details.
Regards,
Marie
?Rows & columns?

?Screen of PL(
Half-yearly)?

?Screen of PL(
Quarterly)?

------------------------------
?? ???
MRI VALUE CONSULTING AND SOLUTIONS CO., LTD.
Japan
------------------------------