cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rspags Frequent Visitor
Frequent Visitor

Re: Dynamic Column calculation based on Slicer Selection

I have tried your solution but am running into an issue.  My dates are not by month like your but rather by week.  Is there a way to update your formula to account for this?  Also, i am trying to look at the data in a slicer by Last 4 Wks, Last 12 Wks, Last 26 Wks, Last 52 Wks, MTD and YTD periods.

 

Thanks for any help you can provide.  I have been trying to figure this out for a while not. 

 

Ryan

Highlighted
jausting Frequent Visitor
Frequent Visitor

Re: Dynamic Column calculation based on Slicer Selection

Hi

 

I dont think its possible to calculate a column based on a sliver value. I have been looking for a solution but unable to find one.

 

I have been wanting to sum the sales for the past 12 months based on a slicer selected date and cannot find a slution anywhere,