aggr and set analysis combination issue

[ajaykumar1]

     Hi All,

    I need a req to fill that we need to write set analysis expression with the combination of aggr and and our normal set analysis.

   I have applied at dimension level and expression level.I am stuck some where at the combination of both.

    Please find the sample data here with.

   Thanks,

   Jaya.infor

[Gysbert_Wassenaar]

I doubt that's possible with chart expressions. You can do it in the script. See attached qvw

[ajaykumar1]

Thanks for quick response.

Can we do that in whether pivot/straight table level in single expression? Because in the script level we have a big data model.Its very helpfull. if we do in design level.That required fields for output are coming from various tables in the data model.

Thanks,

Jaya