I want to createe KPI's.
I have week and year as a parameter.
have columns - week, year, count(customers),sum(value)
KPI's should be created as follows
1. I want to create week summary
2. week on week summary
3. ytd for these columns
also while creating Week on week, need to take care of week 53 of last year and week 1 of current year.
can you please help me out in this.