Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Categories Jedox Web
Created by Guest
Created on Oct 30, 2023

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.

MS desciption UNIQUE
MS desciption VSTACK

  • ADMIN RESPONSE
    Nov 17, 2023

    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?

  • Guest
    Reply
    |
    Nov 17, 2023

    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),