7 Replies Latest reply: Sep 1, 2016 11:11 AM by Sunny Talwar

# How to subtract day wise count from previous consecutive days

Prod1sept201631aug2016
 30aug2016
9aug2016
prod140403532
prod278707064
prod34333
prod414141410
prod5363040

I have a Pivot Table that Show the data Day wise - =Aggr(max(Date(Date#(fetchDate,'YYYYMMDD'),'DD/MMM/YYYY')),fetchDate)

i want to plot another Pivot table that should give the progress day wise (difference between today-yesterday , 31aug-30aug etc,,,) -

Prod

1sept201631aug201630aug2016
prod1053
prod2806
prod3100
prod4004
prod56264

• ###### Re: How to subtract day wise count from previous consecutive days

May be try this:

=Aggr(max(Date(Date#(fetchDate,'YYYYMMDD'),'DD/MMM/YYYY')),fetchDate) -

After(Aggr(max(Date(Date#(fetchDate,'YYYYMMDD'),'DD/MMM/YYYY')),fetchDate))

• ###### Re: How to subtract day wise count from previous consecutive days

its saying "Error in calculated Dimension"

• ###### Re: How to subtract day wise count from previous consecutive days

Is that something you are using a dimension? Would you be able to share a sample to see what you are doing?

• ###### Re: How to subtract day wise count from previous consecutive days

i have a data which looks like -

fetchDate

20160831    prod1

20160831    prod1

20160831    prod1

20160830    prod1

20160830    prod1

20160829    prod1

20160831    prod2

20160831    prod2

20160831    prod3

20160830    prod3

20160830    prod3

20160829    prod3

in a pivot calculated dimension i am using -

=Aggr(max(Date(Date#(fetchDate,'YYYYMMDD'),'DD/MMM/YYYY')),fetchDate)

which is giving the day wise breakup.