Default selections problems

[kkkumar82]

Hi all,

I have two fields fiscal year and cycle, I have created two drop downs using pivot tables and created two buttons where by pressing them default values will be get selected in those drop downs(this is one of my customers requirements).

Its fine until now.

But after this When I try select any other value in the fiscal year I am not able to select a value in the cycle and also the previously defined default value is going off from it. I tried from various trigger options but was unsuccessful.

I am attaching a sample, hope their is a work around in macros.

Thanks

Kiran Kumar

[Kushal_Chawda]

See the attached,

I have changed the expression of cycle

[kkkumar82]

Perfect, it is giving me the way the I want. Only problem here is once you select a cycle if you u want to select other cycle for the same fiscal year, the alternate values are coming up. So for that we have to go back to the fiscal year selection once again.

I think it is a limitation of because of aggr() in cycle calculated dimension.

Thanks

Kiran Kumar

[Kushal_Chawda · Accepted solution]

See the attached.

Hope this will help

[kkkumar82]

Mr Perfect Kush.

Thanks a lot.