Forum Discussion

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
2 years ago
Solved

How can we make the calculation dynamic upon selecting the months in a parameter?

Dear Community,  We have a requirement to calculate the sums of two rows total for every month we run. We have a time parameter that is helping us to select the desired month. We used GetDataCell fo...
Cube View
Dashboards
Parameters
Reports
  • Omkareshwar's avatar
    Omkareshwar
    2 years ago

    Hi Nitish,

    For this situation, you can employ an XFBR rule to retrieve the Getdatacell formula. It should be based on the parameter in the member filter. Reader that parameter in XFBR rule and return you GetDataCell Formula. This way, you can get the desired result using the XFBR rule.

     

Omkareshwar's avatar
Omkareshwar
Contributor II
2 years ago

Hi Nitish,

For this situation, you can employ an XFBR rule to retrieve the Getdatacell formula. It should be based on the parameter in the member filter. Reader that parameter in XFBR rule and return you GetDataCell Formula. This way, you can get the desired result using the XFBR rule.

 

Nitishkrish16's avatar
Nitishkrish16
New Contributor III
2 years ago

Thanks a lot 🙂 Wrote a XFBR rule and it worked!!