Excel Pivot calclated field

17 views Asked by At

I am trying to this:

enter image description here

But it doesn't work - what do i do wrong?

i want to give every region a Target.

Is it even possible to do it via Calculated Field?

Hope someone could help me.

Thank you and have a nice day

1

There are 1 answers

2
Vinyl Wap Viny Wap On

yes, it is possible, you need to use the if statement and as per your formula your if statement is wrong!!