Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
We are having this particular req. at one of our client; They want to analyze week wise performance.
WEEK 1 | WEEK 2 | TOTAL | YTD | |||||||||||
CHANNEL | SUB_CHANNEL | CUSTOMER | BUDGET | TARGET | ACTUAL | BUDGET | TARGET | ACTUAL | BUDGET | TARGET | ACTUAL | BUDGET | TARGET | ACTUAL |
TOTAL | ||||||||||||||
EBO | Total | 100 | 90 | 95 | 100 | 105 | 102 | 200 | 195 | 197 | ||||
EBO-OR | Total | |||||||||||||
W101 | ||||||||||||||
W102 | ||||||||||||||
EBO-SOR | Total | |||||||||||||
W103 | ||||||||||||||
W104 |
On selection week only that week will be visible, Total will show the total value of all selected weeks; While YTD will show YTD value irrespective of week selection.
Here we are facing a issue, we have done till total part but got stuck when in YTD part
Any help would be appricated. . .
Thank You.
In case of any doubt, let me know . . .
YTD?
Hi Saumya,
YTD (Year Till Date), We have to calculate value from start of the financial year till now. This is not the problem. Problem is with this perticular format. . .
Got it ?
You can youse Max(Date)....by which we will get the latest date from the column
Hi prasad,
You can create the YTD flag in back end, and you can exclude week selection from chart using set analysis.
See the attached qvw
see the attched qvw