SUM OF TWO COLUMNS FILTERED ON DATES

AppSheet AppSheet Q&A
, , , , ,
1

Hi,

I’m building an app to record my daily sales summary, so I created a table “Daily Sales” with columns

  1. Date
  2. Daily Cash
  3. Daily Card
  4. Expenses

Here, I want to see the both total of Cash and Total of Cards for any particular dates.

My tries:

  1. I tried adding a dummy column with common value and put it in group by and added “Daily cash” Group aggregate in the views,
    But this helped me to show only total of one column i.e., Daily Cash.
  2. Tried adding virtual column with query “=SUM(Select(Daily Sales[daily cards],True))” and thought of showing it in each rows. It showed the sum but not filtering, for ex: if there are data for one month but when i select date filter for last one week, it shows total of one month only.
  3. Thought of trying with Slices, but since my date condition filterings are dynamic, i’m clueless what to enter on the condition for slices.

Please refer the below images.

Daily Sales.JPG
Daily Sales.JPG987×632 72.8 KB

daily sales2.JPG
daily sales2.JPG985×647 86.7 KB

I hope you understand.

Any help will be highly appreciable.

Thanks.
Syed

2

Hello, you have great idea, check out this video https://www.youtube.com/watch?v=nK-Aq_ak_T8

1 Like
3

In general, you have to create your own filter to have an influence on your dynamic sum, AppSheet filter mostly for showing data

1 Like
4

OMG. The video is mind blowing ?

Thank you so much for sharing the link… :folded_hands:

Perhaps let me try first and will tell if that works out for me. I believe it will work. :folded_hands:

1 Like