# Report & Charts -
**URL:** https://community.glideapps.com/t/report-charts/9156
**Category:** Ask for Help
**Created:** [May 14, 2020, 7:12pm UTC](https://community.glideapps.com/t/report-charts/9156 "2020-05-14T19:12:07Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 14, 2020, 7:12pm UTC](https://community.glideapps.com/t/report-charts/9156/1 "2020-05-14T19:12:07Z")
Goal: We are looking to build reports that shows per user data for following
1. Sales Target assigned vs Target achieved
Its should also show remarks
- Below 10% - Very poor
- 11 to 25% - Poor
- 26 to 50% - Average
- 51 to 75% - Good
- 76 to 100% - Excellent
---
### Author:  [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [May 14, 2020, 7:26pm UTC](https://community.glideapps.com/t/report-charts/9156/2 "2020-05-14T19:26:17Z")
Is the sales data already in the GSheet? Or will the user input the data in Glide?
Where are you stuck at?
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 14, 2020, 7:29pm UTC](https://community.glideapps.com/t/report-charts/9156/3 "2020-05-14T19:29:45Z")
We are at app building stage with fresh google sheet. Need to understand what columns and formula’s need to be implented to show data
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 12:00am UTC](https://community.glideapps.com/t/report-charts/9156/4 "2020-05-15T00:00:59Z")
What is the structure of your data? Can you provide some dummy data so we can have a look?
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 15, 2020, 12:14am UTC](https://community.glideapps.com/t/report-charts/9156/5 "2020-05-15T00:14:57Z")
Yes sure.
Till now I have following column
Col 1: Executive - his email id is there
Col 2: Deal Value - He will enter here value of sale amount he generate
Col 3 :Date of Sale - The date on which sale is generated.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 12:16am UTC](https://community.glideapps.com/t/report-charts/9156/6 "2020-05-15T00:16:43Z")
That is only for the “Sales achieve” part isn’t it? Do you have a separate sheet where you store the “Target”?
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 15, 2020, 12:22am UTC](https://community.glideapps.com/t/report-charts/9156/7 "2020-05-15T00:22:09Z")
I am confused on how to create it, looking for expert suggestion
Goal: We are looking to build reports that shows per user data for following
1. Sales Target assigned vs Target achieved
Its should also show remarks
- Below 10% - Very poor
- 11 to 25% - Poor
- 26 to 50% - Average
- 51 to 75% - Good
- 76 to 100% - Excellent
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 12:27am UTC](https://community.glideapps.com/t/report-charts/9156/8 "2020-05-15T00:27:23Z")
Here’s what I imagine you can setup.
- Sheet A: Deals done
Executive email, Deal value, Date of Sale
- Sheet B: Target & Performance
Executive email, Target (for week or month), Total sales value, Performance remarks
Is this ok to you? You can message me privately to help if you need it.
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 15, 2020, 12:31am UTC](https://community.glideapps.com/t/report-charts/9156/9 "2020-05-15T00:31:56Z")
Target (for week or month) is it two columns
How to get total sales Value
How to get Performance remarks automatically
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 15, 2020, 12:57am UTC](https://community.glideapps.com/t/report-charts/9156/10 "2020-05-15T00:57:27Z")
What do you want to be shown? Target for week or for month? I listed both out as I didn’t know what you want, you can have 2 separate, or just 1 of them, depends on your need.
A total sales value can be achieved with a SUMIFS (conditions being email ID and time constraint).
The performance remarks can be done in Glide with a If \> Then \> Else column.
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [May 15, 2020, 12:59am UTC](https://community.glideapps.com/t/report-charts/9156/11 "2020-05-15T00:59:52Z")
okay let me try