Hi all,
I need to create a table like this in Sense
| | CAD | USD | EUR |
| APPLES | | 10 45.45% | 12 54.55% |
| ORANGES | 7 100% | | |
| BANANAS | 50 62.50% | | 30 37.50% |
| TOTAL | 57 52.29% | 10 9.17% | 42 38.53% |
I already have the values (because I have a flat table to read), so the problem is not the calculation.
The problem is that I don't know how to have 2 values on a single cell. Is it possible with pivot or there is another object that might I use?
Thank you in advance!
Mike
