Built in string function in Set Analysis

[p_andreev]

Hi all,

Is it possible to have something like the following set analysis working?

sum({$< [Month] = "$(=FieldValue('MonthListName',Match(MonthListName,'January','February','March','April','May','June','July','August','September','Octomber','November','December','Total')))"}>} ItrSalesValue)

[swuehl]

Maybe, but what do you want to achieve? How do your data look like, and what is your expected result?

For example, if you select in data island MonthListName, you can try

=sum({<Month = MonthListName>} ItrSalesValue)

[p_andreev]

I will try to explain.

Here is a piece of my chart.

General SubCategory	MonthListName	SALES per MONTH	SALES TOTAL
BRASS LEVEL 3	January	668 873.15	668 873.15
	February	668 873.15	1 337 746.30
	March	668 873.15	2 006 619.45
	April	668 873.15	2 675 492.60
	May	668 873.15	3 344 365.75
	June	668 873.15	4 013 238.90
	July	668 873.15	4 682 112.05
	August	668 873.15	5 350 985.20
	September	668 873.15	6 019 858.35
	Octomber	668 873.15	6 688 731.50
	November	668 873.15	7 357 604.65
	December	668 873.15	8 026 477.80
	Total	668 873.15	8 695 350.95

"MonthListName" field is an inline list combined with "General SubCategoriey" in my script. This is because I need all 12 months for every General SubCategory plus one row called Total for custom calculations of the totals.

Now I want to obtain monthly values (SALES per MONTH) without including months from the calendar as a dimension,but only by set analysis.

I hope this is clear.

[swuehl]

Set analysis won't consider the current dimension value, the set expression is only evaluated once per chart.

Please check

Evaluating "sets" in the context of a dimension

and try maybe the pick / match method mentioned there.

[Brice-SACCUCCI · Accepted solution]

Hi,

could you simply associate the Month field with the MonthListName field?

Here is a sample app.

Regards,

Brice

[p_andreev]

Thank you very much swuehl !

This is very important and helpful material.

Regards,

[p_andreev]

Thank you Brice,

I built my solution taking into account your suggestion.

Best Regards,