Percentage Calculation in Cohort Analysis

[Pericator]

Hello,

I built a Cohort Analysis Table like the image below. But I cant figure out, how I am able to calculate the percentage values of each column and row in Comparison to the first value in the row. 

E.G.: In the 'Juni-2017' column I want the Percentage difference between 2215 and 2159 which is roughly 97%. In the row below I want 100% because 81 is 100% of itself. 

Thanks in Advance 

[sunny_talwar]

What is your expression for Member here?

[Pericator]

Count({<isMember = {1}>}DEALER_ID)

[sunny_talwar]

May be this

Alt(
  Count({<isMember = {1}>}DEALER_ID)/Before(Count({<isMember = {1}>}DEALER_ID))
, 1)

[Pericator]

alt ( ... 

Before(Count({<isMember = {1}>}DEALER_ID))

)

just returns the value, one column before and not the first in the row. 

[Pericator · Accepted solution]

I got it to work with :

left([Member], 1000) / count(distinct total <YEARMONTH>{<isMember={1}>}DEALER_ID) 

YEARMONTH is the upper Dimension. The 1000 is just way overgrowth to make sure, it takes all digits in the field.

Sadly the same doesnt work for my second Pivot, although its exactly the same just with Fees instead of Members. E:G.:

Fee is: Sum({isMember={1}}DBD_LISTING_FEES)

and % therefore should be: left([Listing Fee], 1000)  / Sum(total <YEARMONTH>{isMember={1}}DBD_LISTING_FEES)

But this doesnt work, dont know why though.