Forum Discussion

Sam_OS's avatar
Sam_OS
New Contributor
2 years ago

QTD Column in a Cube View

Hi, Is it possible to bring in two Scenarios in a QTD column that are not Quarterly periods like M5 or M7 or M10. For example if I use Q1 by default it will be March period and for Q2 it will be Jun...
Cube View
SC's avatar
SC
New Contributor III
2 years ago

Hi,

You can use an XFBR rule to dynamically retrieve the scenarios in the report columns based on the current period selection. Use View as 'Periodic' for the respective columns with a 'Total' column at the end.

 

Regards,

S