Day Wise displaying the Data.

[Ramu]

Hi All,

Please help me, 

scenario 1:

I have date dimensions like Day, month, Year and other dimensions are Order Id, Order information, Sales.

My Requirement is:

I have a filters like Day , Brand like that,

If I select the 6 in day filter, I want to display the 1 to 6  days information,

If I select the 20 in day filter , I want to select the 1 to 20 days information Like that

It will display in KPI Like that

If I select the 6 in day filter.

JAN---1500 ----%---14.3%

FEB---5220 ---%---49.8%

MAR---3750 ---%---35.8%

Total---10470

If I select the 20 in Day filter.

JAN---7800 ----%---29.2%

FEB---14350 ---%---53.8%

MAR---4480 ---%---16.8%

Total---26630

LOAD * INLINE [
    Brand, Order Id, Order information, Day, Month, Year, Sales
    PRO, 101, Y, 1, JAN, 2020, 200
    PRO, 102, Y, 2, JAN, 2020, 220
    PRO, 103, Y, 3, JAN, 2020, 240
    PRO, 104, Y, 4, JAN, 2020, 260
    PRO, 105, Y, 5, JAN, 2020, 280
    PRO, 106, Y, 6, JAN, 2020, 300
    PRO, 107, Y, 7, JAN, 2020, 320
    PRO, 108, Y, 8, JAN, 2020, 340
    PRO, 109, Y, 9, JAN, 2020, 360
    PRO, 110, Y, 10, JAN, 2020, 380
    PRO, 111, Y, 11, JAN, 2020, 400
    PRO, 112, Y, 12, JAN, 2020, 420
    PRO, 113, Y, 13, JAN, 2020, 440
    PRO, 114, Y, 14, JAN, 2020, 460
    PRO, 115, Y, 15, JAN, 2020, 480
    PRO, 116, Y, 16, JAN, 2020, 500
    PRO, 117, Y, 17, JAN, 2020, 520
    PRO, 118, Y, 18, JAN, 2020, 540
    PRO, 119, Y, 19, JAN, 2020, 560
    PRO, 120, Y, 20, JAN, 2020, 580
    PRO, 121, Y, 21, JAN, 2020, 600
    PRO, 122, Y, 22, JAN, 2020, 620
    PRO, 123, Y, 23, JAN, 2020, 640
    PRO, 124, Y, 24, JAN, 2020, 660
    PRO, 125, Y, 25, JAN, 2020, 680
    PRO, 126, Y, 26, JAN, 2020, 700
    PRO, 127, Y, 27, JAN, 2020, 720
    PRO, 128, Y, 28, JAN, 2020, 740
    PRO, 129, Y, 29, JAN, 2020, 760
    PRO, 130, Y, 30, JAN, 2020, 780
    PRO, 131, Y, 31, JAN, 2020, 800
    PRO, 132, Y, 1, FEB, 2020, 820
    PRO, 133, Y, 2, FEB, 2020, 840
    PRO, 134, Y, 3, FEB, 2020, 860
    PRO, 135, Y, 4, FEB, 2020, 880
    PRO, 136, Y, 5, FEB, 2020, 900
    PRO, 137, Y, 6, FEB, 2020, 920
    PRO, 138, Y, 7, FEB, 2020, 940
    PRO, 139, Y, 8, FEB, 2020, 960
    PRO, 140, Y, 9, FEB, 2020, 980
    PRO, 141, Y, 10, FEB, 2020, 1000
    PRO, 142, Y, 11, FEB, 2020, 1020
    PRO, 143, Y, 12, FEB, 2020, 1040
    PRO, 144, Y, 13, FEB, 2020, 1060
    PRO, 145, Y, 14, FEB, 2020, 1080
    UNI, 146, Y, 15, FEB, 2020, 100
    UNI, 147, Y, 16, FEB, 2020, 130
    UNI, 148, Y, 17, FEB, 2020, 160
    UNI, 149, Y, 18, FEB, 2020, 190
    UNI, 150, Y, 19, FEB, 2020, 220
    UNI, 151, Y, 20, FEB, 2020, 250
    UNI, 152, Y, 21, FEB, 2020, 280
    UNI, 153, Y, 22, FEB, 2020, 310
    UNI, 154, Y, 23, FEB, 2020, 340
    UNI, 155, Y, 24, FEB, 2020, 370
    UNI, 156, Y, 25, FEB, 2020, 400
    UNI, 157, Y, 26, FEB, 2020, 430
    UNI, 158, Y, 27, FEB, 2020, 460
    UNI, 159, Y, 28, FEB, 2020, 490
    UNI, 160, Y, 29, FEB, 2020, 520
    UNI, 161, Y, 1, MAR, 2020, 550
    UNI, 162, Y, 2, APR, 2020, 580
    UNI, 163, Y, 3, MAY, 2020, 610
    UNI, 164, Y, 4, JUN, 2020, 640
    UNI, 165, Y, 5, JUL, 2020, 670
    UNI, 166, Y, 6, AUG, 2020, 700
    UNI, 167, Y, 7, SEP, 2020, 730
];

scenario 2:

I have Date Dimension, i have two filters in two filters having date dimension.

Date like

1-Jan-2020

2-Jan-2020

3-Jan-2020

4-Jan-2020

5-Jan-2020

6-Jan-2020

7-Jan-2020

8-Jan-2020

9-Jan-2020   Like that

My requirement is , If i select the  5-Jan-2020 in first filter , Next filter I want to display the 6-Jan-2020 date on wards,

Please Help me how will do this one.

Thanks . 

[Taoufiq_Zarra]

@Ramu 

Can you add more detail
for example in senario 1

why does the output only show the values Jan Feb and March? since from 1->6 the other months can also have values?
for the months Jan and Feb I understood, but how do you get the 3750 value for March?

[Ramu]

Hi Taoufiq,

JAN---1500 ----%---14.3%       // sum(Sales) of  Day 1 ,Day 2,Day3,Day4,Day5,Day 6 ---Jan

FEB---5220 ---%---49.8%      // sum(Sales) of  Day 1 ,Day 2,Day3,Day4,Day5,Day 6 ---Feb

MAR---3750 ---%---35.8%     // sum(Sales) of  Day 1 ,Day 2,Day3,Day4,Day5,Day 6 --- Mar

Total---10470         //sum(Sales) of  Day 1 ,Day 2,Day3,Day4,Day5,Day 6    all Months 

If i select 6 in day filter

Jan values is   Sum(Sales) of day 1  - day 6 (Mean day 1,2,3,4,5,6) and Feb, Mar also same,

If i select 20 in day filter,

Jan , Feb having Complete days (Means Jan 31 days, Feb 29 days, But Mar having 7 days only)

Jan is  first 20 days sum(Sales), Feb is  first 20 days sum(Sales)  but Mar having  7 days data so Mar sales sum is sum(sales) of day 1 to day 7. And total is sum(Jan sales of 20 days(Selected days))+Sum(feb sales of 20 days(Selected days))+...

Thanks.