Skip to Content
0
Former Member
Jun 14, 2016 at 07:04 PM

Cross Tab - formula?

24 Views

[R Year] | [R Month] | [Number] | [Profit]


[2015] | [03] | [01] | [4873]

[2015] | [03] | [02] | [3875]

[2016] | [03] | [01] | [4876]

[2016] | [03] | [02] | [3876]

[2016] | [03] | [30] | [5876]

[2016] | [04] | [01] | [4876]

[2016] | [04] | [04] | [4876]

[2016] | [04] | [05] | [1236]


I want to show data in cross tab as below. Take into consideration only the [Profit] for Max(Number) within that month.


2015 2016

-----------------

03 | 3875 5876

04 | 1236


I tried below formula in the cross tab data cell(body axis) but doesnt seem to work


=[Profit] Where (Number] = Max([Number]))