Show Summary of Value List Items

[wallaby]

Hi

I'm new at FM and I'm blocked again. I didn't find a solution so far, regardless what I tried. And after searching fmForums 3 days, I thought I'll give it a try. May be it's very simple and I'm just looking too far?

I have a Value List filled with different Items (in my file called "Kostenstellen").

My idea is to have now on the "Matrix"-Tab a Summary, where it pulls out all Items from the Value List once and shows also on the left side the total of the Costs (total from "AUS Zahlenwert").

Additional: Best would be of course if I could add a search to show it by years (lets say 2006) like I made on the Tab "Listen", where I can sort/filter by month/years.

So far I haven't been able to even get out the Value List into a Portal or Textfield. Is that possibe from a Value List? If yes, how?

I hope my english was clear enough?

Thank you very much for your help.

_ValueList.zip

[sbg2]

Your ValuelistItems field (gTEST) had the wrong information. First you want your calculation to return text, not a number. Second you originally had:

ValueListItems ("Kostenstellen AUS" ; "Value Kostenstellen Aus")

Should be:

ValueListItems("_ValueList";"Kostenstelle Value AUS")

or

ValueListItems(Get(FileName);"Kostenstelle Value AUS")

[wallaby]

Oh, yes, that was it Thank you very much, sbg2.

Now I just need to see how I can get the total summary of the appropriate ListValue.

Thank you very much again, sbg2.