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?
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
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