Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have pivot table as below. I need additional column Balance next to Total and it should calculate from Total-Tar
I am not getting column next to Total. please can anyone suggest me how to do this. I do not have possibility to use cross table.
data | Tar | D | 19/02/2016 | 22/02/2016 | 23/02/2016 | 24/02/2016 | 25/02/2016 | Total |
AA | 32 | 4 | 3 | 5 | 3 | 1 | 16 | |
DD | 32 | 1 | 4 | 3 | 2 | 0 | 10 | |
ADS | 32 | 1 | 4 | 2 | 2 | 0 | 9 | |
dfs | 32 | 100% | 100% | 67% | 100% | 90% | ||
gfd | 32 | 3 | 8 | 3 | 0 | 8 | 22 | |
wed | 32 | 4 | 8 | 6 | 2 | 11 | 30 | |
sdf | 32 | 2 | 10 | 0 | 11 | 5 | 28 | |
hgf | 32 | 7 | 10 | 13 | 8 | 9 | 25 | |
edf | 32 | 0 | 0 | 0 | 0 | 0 | 0 | |
rew | 32 | 1 | 0 | 0 | 0 | 1 | 2 |
I think this is not possible, total is automatically calculated before or after all columns (in the dimension).
is there any possibility in any other way apart from pivot table?
You could add such a column if you added a dimension-value Balance to your date-field (maybe you used two identically fields - one for normal usage and one for this chart and then with Balance) and refers within the expression to them, like:
if(date = 'Balance', sum(total value) - Tar, sum(value))
or you could add simply a second horizontally dimension to your date-field, maybe month and queries this quite similar to the above if-loop with:
if(secondarydimensionality() = 0, sum(total value) - Tar, sum(value))
- Marcus
Tried it . not showing values in column.
what do I need to pass in place of value? in above expressions?
sum(value) is a placeholder for YourExpression and you will need the total-version of them to get the sum over all dates.
- Marcus
sorry I am not getting how to replace my expression with all dates
Please provide a small example app with a few inline-data.
- Marcus