0

How to get difference for 2 consecutive days when using pivot table

I want to create a dashboard that has filter condition to check the difference between current value and prior value ie. Increase> 50000000 and Increase% > 0.05. This filter condition does not seem to work.

The dashboard uses a pivot table and is based on a view created in Business schema which has the relevant variables for current value, prior value, Increase and Increase%.

prior value= if(  BUSINESS_DATE= addDays( BUSINESS_DATE, -1), amount, 0  )

Can someone help me understand what mistake am I doing here?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Snehal, What attributes do you have in column, rows and measure in the pivot table?

    Can you share image of Pivot Table in analyzer view?

    Like
Like Follow
  • 3 mths agoLast active
  • 1Replies
  • 18Views
  • 3 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!