Questions & Conversations

 Hi Everyone,I have a metric based on TRx data (quarter-wise: Q1–Q4) across multiple Accounts, with dimensions including Region and Version (e.g., Forecast FY24).I want to identify the top-performing account within each Region and Version based on the highest TRx value (either quarterly or total for the year).I tried using the RANK function, but I’m only able to rank by grouping on a single dimension. I’m not able to rank dynamically by multiple dimensions together (Region + Version). It seems like the grouping works only for one dimension at a time.What would be the best way to write a formula or configure this in Pigment to dynamically return the top account by both Region and Version?Any guidance on the correct approach

Hi,Can a notification be triggered even when the Automation has been turned off? I have been receiving emails even though I have the notifications turned off. There are no changes in the model history to point to what triggered it. 

Hello Pigment Community,We have replicated our monthly reporting pack in Pigment, which was previously in Google Sheets. One key function (and final touch) that would make it identical to our files in Google Sheets would be the ability to add comments in the right hand margin for each income statement line of our variance analysis.I’ve reviewed Pigment’s commenting functionality, which works well, but is not suitable for our use in this instance. We’re really set on having the comments visible, and being able to archive them. Here’s our specific requirements:Be able to archive comments by period, version (actuals vs. forecast, actuals vs. budget, etc.), and by income statement line.  For example: Imagine I am reviewing the May 2023 Actuals vs. Budget Income Statement variances. I comment to the right of the Revenue line “Revenue underperformed due to X, Y, Z. If in a year’s time, I filter on the month of May, for the May 2023

Hello, I noticed that there were some adjustments made to view aggregators functionality in widget. Previously it was possible to remove the total from the dimensions in grid an copy it over to every metric, but now this button is unavailable. Are you planning to restore it? Thank you! 

Hi everyone,I’m running into a problem with filtering months dynamically based on version in Pigment, and I’m not sure how to handle it. Here’s the situation:Context: I have a table with Version in rows and Month in columns. I created two metrics (both identical, boolean, dimensioned by Month and Version): A filter metric that marks which months are related for each version. Example: New Biz 2025 → Sep-24 to Dec-25 = TRUE New Biz 2026 → Sep-25 to Dec-26 = TRUE A data-entry metric to “open/close” months for each version. This ensures that, when a version is selected, only the relevant months are shown, not all months.

Hello Team, Do we have an option to export Block History in Pigment ? if not, do we have alternatives to do an analysis for the block changes / overrides made by the end-user against the time period. Thanks !  

Hello,I have 3 metrics :- Capa Test (Dimensions: Macro Ressources, Mois)- Charge Test (Dimensions: Macro Ressources, Macro Item, Mois)- Saturation Test (Dimensions: Macro Ressources, Macro Item, Mois) : Saturation Test = Capa Test / Charge Test But as you can see, when I use a multi-selection, the KPI “Saturation Test” doesn’t display the expected result (which would be 132/185 = ~71%).Do you know how I can aggregate this formula in order to have the expected result ?Thank you very much

BonjourExemple :j’ai 2 dimensions, une rayon et une critère, je voudrai pouvoir ne faire apparaitre que les critères relatifs au rayon afin de limiter la selection.J’ai crée une metric de type bolean CP1 , cela fonctionne quand les critères sont exploitées en ligne  mais pas en page merci pour votre aide

I have a transaction data containing 3 columns:QuarterAccountSales OrderI need to insert rank columns wherein the condition is:For an account whenever gets any Sales Order in a quarter, it should be assigned a rank for the line items for the quarter in ascending order of the quarterExample1:Quarter Account Sales Order Rank 2024-Q3         Alpha 100 1 2024-Q3         Alpha 200 1 2025-Q2         Alpha 300 2 2025-Q3         Alpha 50 3 2025-Q4         Alpha 70 4 2026-Q2         Alpha 80 5 Example 2:Quarter

I currently have a table with months and years in the columns and metrics in the rows. I want to have a YoY% appear as a column after each year for all metrics. i.e.    FY26 | YoY% | FY27 | YoY% |Is this possible and if so, how to I go about it?

Hi everyone,I’m a Pigment newbie, and I need support from you !I would like to manually sort the Items of a Dimension displayed in a Pigment Object.Let me show you an example :In the picture below, I want the “NA1” to be between “AU7” and “IN1”.I selected “No Sorting”, but I didn’t manage to drag & drop the NA1.Thank you !​

I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’. ‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’. ‘list1’ has the same properties, with only ‘name’ populated. What formula can I in the ‘product’ property from ‘list1’ to call ‘product’ from ‘list2’ by looking up ‘list1.name’ against ‘list2.name’?

Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred way of versioning in Pigment?  Thank you

Hi Community,I’m currently exploring the Pigment × ChatGPT integration using the new MCP server. However, it appears our IT team is not comfortable enabling Developer Mode in ChatGPT.Does anyone know when the connector is expected to become verified so we can integrate Pigment with ChatGPT without needing to rely on Developer Mode?ThanksNeo

Hi, I just wanted to get some advice on best practice around FX handling when using snapshots.We load our underlying revenue data in local currency and use an FX rate table to convert this to USD. However, it appears that when a snapshot is taken, the USD conversion is locked using the FX rates that are active at that point in time.As a result, when updated FX rates are loaded later, for example FY26 rates, any forecasts that were already snapshotted cannot be recalculated using the new FX table. The snapshot remains fixed to the FX rates present at the time it was taken and cannot be toggled to any FX rates added after the snapshot was created.Any guidance on how others typically handle this scenario would be really helpful. 

Hi,Does anyone know if there is a way to rollback an application to previous version before a certain change was made?

Hi all, I have a strange behavior in some reports: if I collapse a dimension it adds an aggregation.For example I have a report which shows the following list of dimension and only the Months is aggregated inthe columns.In my example the Planning Cycle dimension is not aggregated (which wouldn’t make sense).But if I click on [- FY] to collapse the last columns it automatically activates the Planning Cycle dimension aggregation.The filter is activated automatically:

I’m having an issue restoring an application. I’ve gone through the restoration process but when I open the app I no longer have access to certain key lists:Does it take a while for these to populate or is there another issue with our restoration?

What is the best way to compare two formulas to find differences between them?When updating logic in other systems I typically create a copy of the existing metric. Metric A contains the original logic and Metric B contains the new logic. In order to spot the differences between them, I would create a boolean formatted Metric C with the formula: Metric A < > Metric B. This would return all instances where the logic behaves differently.However this has been a challenge in Pigment due to the way the system handles sparse cells. Am I missing something here? or is there a best-practice for handling these situations?

Hi,I have a metric that pulls data from previous version and has metric override on. In current version, is there a way to delete data that came over from previous version without that cell reverting back to formula based result even if I don’t input any value. 

Hello, I aggregated all the data received from the sales team and it gives me the quantity of bikes to produce for each combination of “Model”, “Colour”, “Fit option” and “Destination”. The combination of those different metrics also lead to 1 unique SKU code. How can I link those unique combination of dimensions to 1 unique SKU  from dimension SKU? Thanks for your help!Ben

I have a P&L that is reported at a local currency.  The department for each line is what controls the currency, and there are over 20 currencies being used.  Reporting needs to be available in Local and four other reporting currencies.  I have a filter to reduce the number of currencies. Currency Filterand a reporting currency dimension, that has currency mapped to it.Reporting CurrencyI’ve been able to convert from local to USD, then from USD to Reporting Currency, but I haven’t been able to go directly from local to reporting without either timing out or having too many blocks to complete the calculation.  Any ideas are welcome, thanks!

Hello, I want to create a table with some KPIs. One of them calculates the number of different suppliers over a period. Transaction list: Invoice (properties: Nb of Invoice (text), Supplier (dim), Month (dim), Cost center (dim) and Value)Dimensions: Supplier, Month, Cost center I used this formula: Invoice.Supplier [BY COUNTUNIQUE: Invoice.supplier, Invoice.Month, Invoice.'Cost center'] It works well if I filter my view by month. But as soon as I select my entier year, it adds everything up (1,002) instead of counting the unique suppliers over the year (100). It's not the MAX function either, which would give me 98 as result. I expect this result:Jan 25    85Feb 25    70Mar 25    86Apr 25    78May 25    77Jun 25    79Jul 25    79Aug 25    98Sep 25    85Oct 25    78Nov 25    98Dec 25    89FY 25    100 Thanks for your

Hello,I was wondering if it is possible to create a CAGR % in a table (via calculated items or SVA). At the moment I have a separate metric that calculates a CAGR on a granular P&L level, but once I pull that metric in my table it simply sums or flat-out averages that metric for the higher P&L levels.Does anybody know if there is some smart way to recreate a CAGR SVA or calculated item in a Pigment table?Thanks, Bas