# Sum is not shown when on top **URL:** \ **Category:** Ask for Help\ **Created:** [July 4, 2020, 9:36pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980 "2020-07-04T21:36:35Z")\ **Posts on this page:** 11\ **Page:** 2
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 8:16am UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/21 "2020-07-05T08:16:21Z")
@ThinhDinh if I understand the way is to sign in Sheets if each entry is this week, last week. Only then to make relations. I’m asking because I understand you are in favor to use glide data editor where available, other than Sheets formulas ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 5, 2020, 8:17am UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/22 "2020-07-05T08:17:05Z")
Yeah that’s what I meant, but if you want to aggregate it using Sheets then you can use a simple Query function as well. Whatever works for you 😄 ---
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 11:52am UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/23 "2020-07-05T11:52:20Z")
@ThinhDinh I got lost over again I created that new column in expenses table, evaluate the week by date and have one of 3 values {this week; last week; 2 weeks ago} in totals sheets I have 3 entries - I put there “total” computed by google sheets but also used the relations and then rollup - of glide - following your recommendation. as you see values are match 🙂 BUT - it does not shown when using text component - to show that value. without filter - it shows me last row, and with filter - on week column - nothing ☹ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0011a527f2b1753db4fb47623899c71420a83e5a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a83ae6215038127485d1b289e4c020c0e2fe6d87.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/20e1fd48a2eb2479f8bcc680a6f5ee9d9bfe73df.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 5, 2020, 12:34pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/24 "2020-07-05T12:34:16Z")
What is your screen settings for the one you’re trying to have this text on? ---
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 12:42pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/25 "2020-07-05T12:42:55Z")
screen settings? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 5, 2020, 12:51pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/26 "2020-07-05T12:51:45Z")
The layout with components for the screen you’re trying to have this text shown. ---
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 12:55pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/27 "2020-07-05T12:55:12Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c4f59cc3f1ad97b33531837fded62b3325d8d7c5.png) it is built from: 1. show total so far for this week 2. button to form to add new expense 3. list of expenses so far for this week ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 5, 2020, 1:13pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/28 "2020-07-05T13:13:59Z")
You have 3 rows for this sheet right? You have to filter the sheet by the week you want to show, if I get it right. ---
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 1:16pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/29 "2020-07-05T13:16:48Z")
this is what I tried. believe me ☹ This was attached before . and again: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/20e1fd48a2eb2479f8bcc680a6f5ee9d9bfe73df.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 5, 2020, 1:17pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/30 "2020-07-05T13:17:20Z")
You are filtering that by the text component, I mean you should filter it in the “Features” settings for the whole tab. ---
**Author:** ![Eyal\_Orbach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyal_orbach/32/3791_2.png) [@Eyal\_Orbach](https://community.glideapps.com/u/Eyal_Orbach)\ **Post date:** [July 5, 2020, 1:23pm UTC](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980/31 "2020-07-05T13:23:03Z")
done. solved 🙂 many thanks [Previous page](https://community.glideapps.com/t/sum-is-not-shown-when-on-top/11980.md?page=1)