First sorted value based on expressions

[venkatg6759]

Hi Everyone,

I have a table as shown in the attachment .

I have rating date and Author Name in dimensions and

Rating field has buy ,sell,neutral .................

where we count the # buy,# sell in expressions .

I need to get the most recent rating date for each of the  rating count  .

Any ideas on this ?

Thanks,

Venkata

[giakoum]

aggr(max([rating date]), [Author Name])

[swuehl]

Could you post a small sample QV app and your expected outcome (e.g. as Excel table or bitmap)?

[venkatg6759]

I got what i need but how can i represent the same in a bar chart .

Check the attachment.

Thanks,

Venkata

[msteedle]

Represent what in a bar chart?

[SunilChauhan]

firstsortedvalue([rating date]), -[Author Name]

try this this

hope this helps