Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to do some strange things, namely:
i have some field, filled with variables names
For examle
Field:
-----------
Year
Month
Day
where Year, Month & Day are fields in other tables
In chart I wnat to hane an expression like =sum($(Field)
I mean if Filed=Year then expression should be sum(Year)
Is it possible to do this?
If i understood your Question properly.Your expression should be like =sum($(=Field)
Check out the attached application.
Hope this helps you,
-Sridhar
Hi,
I think you need to write a code some thing like below for expression calculation
=If(Getfieldselections(Year),Sum(Value))
See sample file
HTH
Rgds
Anand
If Year, Month and Day are in different tables, just refer to them with the same fieldname so they all will line up irrespective of Yr, Mth or Day.
Here is what the script look like (modified what Anand had attached previously).
Hi,
In this type of requirements make a composite key which contains Year Month and Day values and use this key so in this case your problem solve with this you need to use this key as dimension.
HTH
Let me know tomorrow it is too late.
Rgds
Anand