Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i uploaded excel file for easy reference of u
i want sales house sales of for the month of aug and sept only that to in staright table
i want the fruits wich was sold in house
house | shop | houe rate | shop rate | |
Apple | 10215 | 10 | 0.6 | 0.6 |
mangoes | 55472 | 55472 | 3.9 | 3.9 |
banana | 32 | 32 | 0 | 0 |
dry fuits | 352 | 724 | 0 | 0.1 |
tamatoo | 34437 | 34904 | 0.6 | 0.7 |
total | 9850 | 101347 | 1.1 | 1.1 |
hi there is no attachment as such and regarding the query you can simply write three Expressions
Sum({<Year = {$(=max(Year))}, MonthNum= {08}>}sales).... Difference
or can use Max(MonthNum) and Max(MonthNum)-1 same as Year to make dynamic