Skip to Content
0
Aug 22, 2023 at 09:41 AM

Total Result of Keyfig in query should not be displayed if the 12 months data are not available.

129 Views Last edit Sep 06, 2023 at 07:06 AM 2 rev

keyfig-total.png<br>

We have a requirement to display the aggregation total(Result row) of key figures for the query as below

1 .If User executes data for 12 months ( CALMON - 01/2023 to 12/2023)-- Result row should get populated
2. If User executes the report for few month not for 12 months - Result row should populate as 'X'.
Please let me know if there is any possible way to do this in sap BW query.

<br>

Attachments

keyfig-total.png (1.0 MB)