When selecting more than 6 months, current selection box is showing the month not selected

[#1]

Hi All,

I have attached a applicaion, in which i have created a straight table with some details. When i select first 6 months (Jan till June) the table is showing the details for the selected month. But when i select more than 6 months( example Jan till july) it is showing the month which are not selected. How can i fix this.

Regards,

Gerard

[Sokkorn · Accepted solution]

Hi,

Let use Conditional in Hide/Show by SubStringCount(GetFieldSelections(Month,',',100),'Jan')>0

See sample attached file.

Do let me know after you tesed.

Regards,

Sokkorn

[#3]

Hi Sokkorn,

Its working perfectly, thanks a lot. I have attached the same application with one more table chart. I dont know how to make those two charts into one, by using a spinner. Since dimension that we are using is vendor name in both the charts. Only expression differs and they are amount corresponding to month and Invoice number corresponding to month. I have included sum and avg also. Since i need it.

Regards,

Gerard

[Sokkorn]

Hi Gerard,

Let check in the new attached file.

Do let me know if you need more support.

Regards,

Sokkorn

[#5]

Hi Sokkorn,

The problem is i want that chart to have a spinner. The spinner should have amount and invoice number. So that i can select any of one of them. Along with it i want to see the sum and average of it.

Regards,

Gerard

[Sokkorn]

Hi Gerard,

I'm still not understand what you want to achieve event I try to read your msg more than 5 times. Can you manipulate the end result you looking for? If can send me the screenshot you need to achieve.

Regards,

Sokkorn

[#7]

Hi Sokkorn,

Pic 1 gives the Sum of amount

Pic 2 gives the count of invoice number

Above pic are just a example. I want a single chart with a spinner for Sum of amount and Count of spinner.

Regards,

Gerard