Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please post a more detailed description of your data model, dimensions and expressions used in that chart.
Best by uploading a small sample QVW.
try this calculated dimension in cyclic group
=aggr(Only({<Date={"$(=date(max(Date)))"}>}grade), agent)
It's works for the agent but not for the field.
Thank you anyway