asked on September 25, 2020
Hi, noob here to Flexmonster. I have a data source that has three "dimensions" (sort of like a fact table in data warehouse speak). Each of these dimensions can have a character value. So the table looks something like this:
Department Risk Scale Risk Type Value
ABC Inherent Risk Strategic Risk Minor
ABC Residual Risk Financial Risk High
...
...
I'd want my pivot table to be such that Department is present in the "Report Filters", Risk Scale is in the "Rows" and Risk Type is in the "Columns". However, I'd want the values to represent the actual values here, i.e. "Minor", "High" and so on. It's safe to assume that for any combination of the three dimensions there is always going to be 1 "Value" field.
Is there a way to do that using Flexmonster?
Thanks!
⋅ September 29, 2020
Hello, Kabir,
Thank you for writing to us.
Taking into account your case, we would like to suggest a workaround:
Please change the values of the "Value" field by switching from string to number type. For example, replace "Minor" with 1, "High" with 2. Then define the aggregation for the "Value" measure that will not change its value: for ex., "max". Finally, use customizeCell API call to change numeric values to the corresponding string values.
We have prepared an example for illustration: http://jsfiddle.net/flexmonster/ogd497t6/.
Please let us know if it helps.
Best regards,
Milena
⋅ October 9, 2020
Hi, Kabir,
We were wondering if our response helped you with your question.
Could you please let us know whether the provided example works for your case?
We would be happy to hear your feedback.
Best regards,
Milena
⋅ October 20, 2020
Hello, Kabir,
We are just checking in to ask if you have found our response helpful.
Did you have a chance to check the suggested workaround?
Looking forward to hearing from you.
Kind regards,
Milena
