Monthly vs Yearly Cube View Data
Hello everyone!
I require some assistance regarding the following objectives that I have in mind for this cube view.
- Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year.
- Getting a percentage by using the monthly data / current year.
Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table.
For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025.
Please advice on how I should approach these issues or any improvement or suggestion I should be doing.