Aggr / Only functions problem

[#1]

Hello,

I have  a table that contains field, agent, date, grade and others.

In the dimensions i have a cycle with field+agent. I need to add the grade of the maximum date that had been chosen.

HOW CAN I GET THESE:

The cycle for agent should look like:

agent    grade     num of agents

1              3               1

2              4               1

The cycle for field:

field      grade    num of agents

A          3              4

            2              3

            1              4

B    .....

I tried to do only func with a set analysis but it didnt work for the fields.

i tried to use AGGR func, but it didnt work to.

Do you have any ideas?

[swuehl]

Please post a more detailed description of your data model, dimensions and expressions used in that chart.

Best by uploading a small sample QVW.

[Kushal_Chawda]

try this calculated dimension in cyclic group

=aggr(Only({<Date={"$(=date(max(Date)))"}>}grade), agent)

[#4]

It's works for the agent but not for the field.

Thank you anyway