Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to use altenate state to make analysis on 2 periods, for this I use 2 alternate state "Period1, Period2" and I have set this on Year and Month fields.
Now when I create my chart and I write the expression do
=sum ({[Period1] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)
=sum ({[Period2] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)
Exist a way to don't write the part between < ... >?
I have many fields and is boring to write always all fields only to specify $::
Regards
Luca Jonathan Panetta
Hi, Luca,
try something like this, where FIELDNAME is the field you select in your alternate states:
=sum({<FIELDNAME = [Period1]::FIELDNAME>} Sales)
Greetings from Munich
Martina
EVACO GmbH
Hi ,Luca...you can use a variable and each time write the variable to get the appropiate results////
regards
Kamal
Hi Kamal,
yes, I can use a variable but I want to find a new way to do this.
Edit: want to
Regards
Luca Jonathan Panetta
Hi Luca...can you shate the new method of solving this with...I will be thankfull to you.
regards
Kamal