how to bypass the field with the before function

[kavita25]

Hello Everyone,

I want to bypass or restrict the field from the before function. Following is the logic I am using:

(Before (total
(RangeSum(Before(count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo()))),18))

Or let me know how can I achieve the previous year data with the logic:

count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid)

Thanks & Regards,

Kavita

@tresesco @sunny_talwar 

[kavita25]

Hello Everyone,

@sunny_talwar 

I am still struggling with the below logic.

Is there any way to bypass the filter inside the before total using the below logic:

 (Before (total
(RangeSum(Before(count (distinct {<month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo())))

As i want to use two before to get the previous month using Rangesum and for accumulation for the previous value.. I am using Before and Rangesum in the pivot table.

Regards,

Kavita

[sunny_talwar]

Can you share a sample where we can see the issue?

[kavita25]

Hello @sunny_talwar 

I have attached the sample file. My requirement is to show the previous year rangesum values in the current year in pivot table.

I have tried the below logic:

(Before (total
(RangeSum(Before(count (distinct {<Year=, Month-={'Q1','Q2','Q3','Q4','YTD','FY'}>}complaintid),0,ColumnNo()))),18))

It works.. but on year selection it shows blank values.

Thanks..

Regards,

Kavita

[kavita25]

@sunny_talwar  : Is there any other way to resolve the issue or what I am doing is not correct??

Please guide me on this.

Regards,

Kavita

[sunny_talwar]

@kavita25  What is the expected output? Would you be able to share the output you expect to see in an Excel file?

[kavita25]

@sunny_talwar : I have attached the output.

Basically I want to show the data of Previous year in Current year with the rangesum logic.

Thank You.

Regards,

Kavita

[kavita25]

Hello Everyone,

Kindly help me to resolve the issue, I have tried the same multiple times.

@sunny_talwar @Taoufiq_Zarra .

Regards,

Kavita

[kavita25]

@sunny_talwar @Taoufiq_Zarra  Is there anyway to show the previous year in current year with the rangesum function?

Please let me know, facing the same issue, need your help.

Regards,

Kavita