Forum Discussion
Display Week end (Friday) or Month End results based on filter selected
Hi Herbert
Thanks a lot. It was very helpful. I have another lookup field from another table along with Revenue which needs to remain constant and not aggregated. When I add that as column in Table 1 it displays for daily. But when monthly or weekly it aggregates and shows the sum rather than constant amount. If i select don't aggregate then it displays individual record values rather than single record for a month or week
Eg
Agent Rev Goal Date
A 100 140 01/01/2016
A 150 140 02/01/2016
When month selected it shows
A 250 280 January
or when not set to Don't aggregate
A 100 140 01/01/2016
A 150 140 02/01/2016
Is there anyway to display it as
A 250 140 January
Microsoft Employee
Which table does the Goal column belong to? What is the relationship between the Goal table and Table1? Please give a sample of Goal table if possible.
Best Regards,
Herbert
Hi Herbert
The Goal comes from the same table or I can have another view to lookup that Goal value based on agent name
- v-haibl-msft
You can try to delete the Day hierarchy from Table Values field as below. If keep the Day in it, the date will be distinct and there will be multiple results returned.
Best Regards,
Herbert
Hi Herbert,
Thanks a lot. It worked well. I have another query. I need revenue difference calculated from today's data with previously loaded data. The issue is that there will be gaps in load dates. Example below. Is there any way to find the immediate predecessor date for a particular load date
Agent Revenue Last Load date Revenue Diff (today's revenue - previous day loaded revenue)
A 300 03/10/2016
A 400 05/10/2016 100
A 600 07/10/2016 200