current to future only

[soniasweety]

Hai all,

Tresesco B

i have data like  region quarter    value, is there    below is my requirment

Req :  the pivot table should show the  result for  from current quarter to till futer quarters avaiable in data

means:  current quarter 2018Q4   to - 2030Q3  (   old quarters data should not sum /count in the result table)

Thanks

Sony

[Frank_Hartmann]

exp1:

count({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}deal)

exp2:

sum({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}Value)

[Frank_Hartmann]

What else do you expect to get a correct answer instead a helpful one?

[soniasweety]

thank you  sir its working ..franky_h79

but if i want to add one measure  which  is

metric: service mix % =  services/totalvalue

how can i do this?  services is type  i want  servicemix% for only service not for hardware.

i want the result shown in image,

[Frank_Hartmann]

see attached

[soniasweety]

thank you  its showing as i expected but i want to show  number of deals also  if you can see screen shot.  its there 

[Frank_Hartmann]

updated qvw, see attached

[soniasweety]

sorry i got it  i added number of deals thank you

one last doubt -

this is for  current and next all future quarters   :count({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}deal)

in same way i want the expression for   current and next3  (for ex:- 2018Q4,2019Q1,2019Q2,2019Q3 ) quarters how can i write in set analysis ?

[Frank_Hartmann]

see attached

[Frank_Hartmann · Accepted solution]

sorry forgot one equal sign

see attached