asked on July 29, 2025
We have a use case where a pivot table can be made up of multiple currency values. We force a user to dimension based on the currency code, so the same currency amounts are grouped together and disparate currency amounts are not aggregated together. We would like to apply conditional formatting for currencySymbol to the currency amount based on the currencyCode dimension. Is there a way to do this today in FlexMonster?
⋅ July 30, 2025
Hello, Bill!
Thank you for reaching out to us.
Flexmonster does not support number formatting with conditions based on other cell values; it only applies formatting to a specific measure. We recommend using the customizeCell function (an API call that allows the customization of separate cells) to apply conditional currency formatting. When processing cells, you can implement a condition based on the adjacent member in rows or columns, based on which the cell text can be modified to include the appropriate currency symbol: https://jsfiddle.net/flexmonster/mkhwgxto/
Please let us know if this solution would work for you.
Best Regards,
Maksym
⋅ August 6, 2025
Hello, Bill!
Hope you are doing well.
We are wondering if you have time to check the provided solution for formatting cells based on adjacent member values using the customizeCell.
Please let us know if it works for you.
Best Regards,
Maksym
⋅ 9 hours ago
Hello, Bill!
Our team would like to know if you tried using the customizeCell for formatting values based on member cell data.
We are looking forward to hearing your feedback.
Best Regards,
Maskym
