Hi everyone,
I would like to export to excel from QlikSence to a specific format.
In my app, i've a cross-table like this
| Working directory 1 | totals | Working directory 2 |
totals | 12 | 12 | X |
ID1 | 6 | | X |
ID2 | 6 | | X |
Totals | 3 | 3 | |
ID3 | 3 | | |
i would like to have somthing like this and export to excel
| Working directory 1 | totals | Working directory 2 |
totals | 12 | 12 | X |
ID1 | 6 | | X |
ID2 | 6 | | X |
% | "ratio 15/6" | | |
Totals | 3 | 3 | |
ID3 | 3 | | |
| "ratio 15/3" | | |
is there an easy way to do this?
Thanks.