I want to see % for 2017 per customer and same as for 2018.
For eg : if total sales 100k and cust1 have sales of 10k and 20k for 2017
and 2018 respectively then i should get values as 10% and 20% for the years.
And based on this values i will create Calculations for the Text.
See the output sheet in attached file.
On Wed, 8 Aug 2018 at 8:14 PM, Zhouyi Zhang <email@example.com>
Let me make is simple.
I want to calculate percentage per customer for the year 2017 which will be
I want to calculate percentae per customer for the year 2017 again which
will be PYTD i.e Jan to June.
So now if % age exceeds 100% for the year 2017 PY Then i will update the
text mentioned in the excel.
Again for PYTD i have to check the same.
If you give me Calculations to find % age of cuatomer for each year and
period then i will guide you the next step or i will try to do from my end.
Let me know if you have any questions.
Please find attached the solution
SUM([YTD Sales 2018])
SUM([PY Sales 2017])
sum([YTD Sales 2018])
SUM([PYTD Sales 2017])
solution - Tausif.twbx 47.1 KB
Your solution was perfect for what i was looking for.
Will let you know if i need further assistance on this.