I am trying to create a formula or conditional format for my pivot table that shows the trend from the previous month using the arrow up, down and dash icon. if the % change exceeds a specified threshold the arrow would be up. If the % doesn't change from the previous month then it would be a dash and if the % change is lesser than the previous month the arrow would be down. My threshold base will be the May volume. Each month after will follow the threshold from the previous month to verify the trend.
Bookmarks