Filtered summary portal problems

[Richard Burrow]

Hi all - thanks in advance for any help you can offer. 

 

I'm currently working on a report to show average keyword ranking (in Google search results) for a group of keywords, reported at monthly intervals. 

 

I have a table which stores the average ranking position of 4 keywords, "marzipan", "flower paste", "ready to roll icing" and "fondant icing"

each month (stored in field "SR_Keyword_Position")

 

In this table I also have a summary field ("SR_Average") which calculates an AVERAGE summary of field "SR_Keyword_Position"

 

I have a list layout for this table with a sub-summary part which has the "SR_Average" field on it which summarises the average ranking for the group of keywords, when the list is sorted by date. (See attachment)

 

PROBLEM TO SOLVE:

 

I am trying to create a filtered portal on a related layout which only shows 1 row per month, 

showing just the month name, and the month average keyword ranking.

 

EG:

 

December 2013            8.5

January 2014                7.6

February 2014              7.6

 

 

Please help!

[eos]

See if this helps you:

FilterbyMonth_eos.fmp12.zip

[Richard Burrow]

Thats exactly what I wanted to achieve. 

Now to deconstruct it.... how did you achieve this wizardry?

 

looks like calculation fields, and self join relationships?

[Richard Burrow]

and a case statement in the portal filter.