Hello Experts,
We want to create a report using IFS business reporter which includes a pivot table. For this we have first created a flat table on a sheet and the pivot table on another. (Please note we need to create the flat table using report designer and then create a pivot table using excel functions since it is not integrated to business reporter as it was in IFS Business Analytics)
We have defined a parameter as Site and want to display it on the report when it is run. For that we have dragged and dropped the parameter name and parameter value from the document action pane to the sheet.

We have done the same for other sheet where we want to see the pivot table, but with a different formatting.

The cell formula for these values are as below.




However when we run the report, these values are shown correctly only on the flat table sheet. On the pivot table sheet they are not updated but only show the field names as ‘[SITE.Name]’ & ‘[Site]’


How can we have these values updated on the pivot table sheet?
PS: We have been working with IFS Business Analytics and this has been working without any issue.
Thank You in advance.