Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Have a table with having 3 fields..like below
month | rating | active |
jan | A | 21 |
jan | B | 22 |
jan | C | 23 |
jan | D | 24 |
feb | A | 25 |
feb | B | 26 |
feb | C | 27 |
feb | D | 28 |
mar | A | 29 |
mar | B | 30 |
mar | C | 31 |
mar | D | 32 |
Output:
month | rating | active | Outputresult field |
jan | A | 21 | |
jan | B | 22 | |
jan | C | 23 | |
jan | D | 24 | |
feb | A | 25 | 21 |
feb | B | 26 | 22 |
feb | C | 27 | 23 |
feb | D | 28 | 24 |
mar | A | 29 | 25 |
mar | B | 30 | 26 |
mar | C | 31 | 27 |
mar | D | 32 | 28 |
Here am attaching the Qvw for the same which i tried.
Basically every month having 4 type of ratings and their activity.
Want to show for jan month activity should show in feb activity and feb activity should show in Mar activity....
I have been used some functions with combination of above but am not getting correct result.
Thanks in advance...
You've almost done it.
Just change the order of aggr dimensions
only( aggr (above(sum( {$<month=,rating=>}active),1,4),rating,month))
Hello,
Maybe:
month | rating | sum(active) | above(TOTAL sum(active),4) |
---|---|---|---|
318 | |||
jan | A | 21 | |
jan | B | 22 | |
jan | C | 23 | |
jan | D | 24 | |
feb | A | 25 | 21 |
feb | B | 26 | 22 |
feb | C | 27 | 23 |
feb | D | 28 | 24 |
mar | A | 29 | 25 |
mar | B | 30 | 26 |
mar | C | 31 | 27 |
mar | D | 32 | 28 |
Just ensure that your table is sorted by month then rating.
Regards
Andrew