Skip to main content
J
JoelBeh
April 7, 2025

Monthly vs Yearly Cube View Data

  • April 7, 2025
  • 1 reply
  • 1 view

Hello everyone!

I require some assistance regarding the following objectives that I have in mind for this cube view.

  1. Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year.
  2. 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.

 







 

1 reply

C
chul
May 6, 2025

If there's no requirement to store the result, you could write a dynamic calc that uses the month number as the numerator and the YTD number of the most recently submitted month as the denominator.

Terms & ConditionsAccessibility statement