Support UNIQUE and VSTACK Excel formulas in Jedox web reports
Please add in Jedox web the support of the Excel formulas UNIQUE and VSTACK. Additional add the support for those formulas for excel snapshot and PDF export as well.
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. Could you please add further information and use cases of this feature?
Use case: Customer would like Jedox data as a starting point, but continue input work In pure excel, where they are more comfortable. While working in excel, they would like formulas to still work, to get an instant overview of numbers. Intended setup: Customer opens Jedox report, uses XLSX OLAP Snapshot. Customer works in excel, inputting numbers as wanted. Finally, customer uploads again to Jedox.
Specifically, the use case has jedox report sheets: Sheet1 with Actual numbers, and Sheet2 with forecast - in rows for exmaple Products. The intention is to collect the numbers i Avtual and forecast in one shared sheet, which updates as customer inputs further in forecast sheet in excel. This in sheet 3 "full overview". Generaing the list of unique products, based on Actual and Forecast sheet, would have been very natural using VSTACK and UNIQUE, but these are not supported in XLSX Olap Snapshot (probably not supported in Jedox at All),
Use case: Customer would like Jedox data as a starting point, but continue input work In pure excel, where they are more comfortable.
While working in excel, they would like formulas to still work, to get an instant overview of numbers.
Intended setup: Customer opens Jedox report, uses XLSX OLAP Snapshot. Customer works in excel, inputting numbers as wanted. Finally, customer uploads again to Jedox.
Specifically, the use case has jedox report sheets: Sheet1 with Actual numbers, and Sheet2 with forecast - in rows for exmaple Products.
The intention is to collect the numbers i Avtual and forecast in one shared sheet, which updates as customer inputs further in forecast sheet in excel. This in sheet 3 "full overview". Generaing the list of unique products, based on Actual and Forecast sheet, would have been very natural using VSTACK and UNIQUE, but these are not supported in XLSX Olap Snapshot (probably not supported in Jedox at All),