straight table

[denis115]

Hello!

I need help!

I have a table where I have :

prodname

sales_sum

start sales

last sales

and when I select big period of time I need to see in : sales sum (sum of sales in this period)  ,  start sales (sales of first month selected)

and last sales (sales of last month selected)

how can I do this?

Thank you!

[tresB]

Can't open. Could you check and may be share a smaller one?

[denis115]

TEST

[tresB]

Which fields are date, month, year, sales?

[denis115]

I have start date "Начало месяца" and last date "Конец месяца"  as you can see, only  at last sheet I need to have in

columns "ОНН"  Sum ([Ост.Начало Стоим.])   for  lower month of selection and in  "ОНК" the  higher month of selection

for example I select : apr,may,june,july  in col OHH I NEED TO SEE SUM ([Ост.Начало Стоим.])    only apr because it is lower month from selection

[tresB · Accepted solution]

Try:

Sum ( {<[Начало Месяца]={"$(=Min([Начало Месяца]))"}>}[Ост.Начало Стоим.])

Sum ( {<[Начало Месяца]={"$(=Max([Начало Месяца]))"}>}[Ост.Начало Стоим.])

Note: If you wish to select from another date field, you might have to include those date fields as well in the expression to nullify it's effect. like:

Sum ( {<[Конец Месяца], [Начало Месяца]={"$(=Min([Начало Месяца]))"}>}[Ост.Начало Стоим.])

Sum ( {<[Конец Месяца], [Начало Месяца]={"$(=Max([Начало Месяца]))"}>}[Ост.Начало Стоим.])

[denis115]

Thank you!!! it works!

[HirisH_V7]

Bro u know that language super.