Forum Discussion
Disconnected Sicer with Different Data Types
Hello all, I am building out a matrix and one of the requirements for this matrix is to have the measures in the rows section of the table. I was able to achieve this by creating a disconnected t...
Hey,
I'm wondering if this will provide what you are looking for:
Mark the matrix table and in the formatting section simply switch the property "Show on rows" from the Values band.
Regards,
Tom
Hi Tom,
Thanks for your response. Unfortunetly, that didn't work. I'm still getting 0 for values that should be percentages.
Hey,
do you use the original measures and did you check the "Format" option for each value from the formatting ribbon from the "Modeling" menu:
Regards,
Tom
Yes. All the measures that are formatted as "Whole Number" appear. Measures that are formatted as "Percentages" come back as 0.