How to show total using Rows & columns
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
------------------------------
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
------------------------------
0
Answers
-
Dear Marie,
which Board version are you working with?
Generally speaking it should show what you are trying to see without issues, if the behavior is unexpected we need to check better what you are building and how it is built.
Could you provide more details about the layout and the cube dimensions?
If you prefer, you can open a ticket on our Support Portal (https://support.board.com ) and we will organize a web-call to analyze the issue together.
Hope this helps!
regards,
federico
0