2
$\begingroup$

New to Tableau and having some problems with a calculation I thought would be easy.

I have data with one value per month running across a few years. I would simply like to display a table with the change from month to month in percent and the change from start of year to end of year in percent as a grand total.

The input data looks like this: Example of raw data

And I would like to create a table like this: enter image description here

The month to month change is easy enough using a table calculation with "Percent difference from" and "across then down", but the yearly change has me frustrated by now as I keep getting weird values. I tried to create a calculated field using offsets in the table, but of course it doesn't work when applied in grand total using the 'Size()' trick.

Any tips?

$\endgroup$

1 Answer 1

0
$\begingroup$

Across_then_down calculation works fine with row grand totals. enter image description here

What do you mean by 20% in the first row Grand Total in the 'output' table? 20% relative to what?

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.