Inputfield for a selection

[#1]

Good evening,

I used a a inputfield to specify a value that can change in my table, a number of stores. But considering my table contains a lot of rows, how to edit the field value for a selection? for exemple add a store and go from 4 to 5 stores in one time instead of changing the value for each line.

Thank you a lot !

[#2]

I did the same as at the attached file, but I have a probleme, for the table with period and number of stores, I have as many lines as sales lines. Is it normal?

[sunny_talwar]

That should not happen, If period are all the same, they should all be clubbed together into one. Do you have any other field in that particular table box???

Best,

Sunny

[#4]

Yes I do. I have a field date transaction from wish I create fields: Day DayMonth and Month and Hour. In the last table I picked the Month field and added the number of stores. But as an output I have a table with a lot of each month

[sunny_talwar]

From my what I understand, you need to do this in your script:

[Number of Stores]

Month:

LOAD DISTINCT MonthName(Date) as Month (This 'Month' should be the same name as in your fact table or master calendar)

          [Number of Stores]

Resident [Master Calendar] or [Fact Table];

Then on the front end of the application create a table box with just Month and Number of Stores and I think it should fix the issue for you.

Hope this helps.

Best,

Sunny

[#6]

I tried this but I have a error message saying I have a duplicated keys

[sunny_talwar]

Is there any way you can share your or a sample application?

Best,

Sunny