Christmas tree as a Quantrix chart?!
Wishing you high values of Happiness, Love and Joy in 2022. This time with a Christmas tree chart (!) created in Quantrix #love #happiness #gobeyondexcel

Wishing you high values of Happiness, Love and Joy in 2022. This time with a Christmas tree chart (!) created in Quantrix #love #happiness #gobeyondexcel

Business forecasting is one of the most important capabilities for any organization that wants to plan effectively, allocate resources wisely, and respond to market changes with confidence. Whether you work in retail, manufacturing, finance, or supply chain management, the ability to predict future demand, revenue, or operational needs can dramatically improve decision‑making. In this guide,…
A success story of the company whose Large Corporate Budget including 60 Facilities in 6 Regions around the country was created using Quantrix Modeler and Smart Modeling Solutions services only in 10 days. Growing complexity of a business and consequently models has made using Excel not reliable option. Company has cut its budgeting time from…
I think the most interesting way of using role names is in creating different views of the same Matrix based on the role. This means users with different roles will see different parts of the matrix assigned to them. We can do it by using the role name variable in filter expression. You save your…
It is possible to reorder items based on values via script (an example shown below). It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). One can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different.
To enhance the filtering process and provide an option to show all items, user can consider adding an “ALL” item to the dropdown list (this can be done via concatlist() or the generate items feature). When a user selects “ALL,” the entire table will be displayed. This approach may be more intuitive for users, as…
This almost 30 years old article promises that Lotus’ Improv for Windows will change the way people create and look at spreadsheets. With Excel dominating the market, these amazing advantages of Lotus Improv are almost forgotten. But they are still valid today.Luckily, we have all these amazing concepts of Lotus Improv in Quantrix for those who want…