Need help in Pivot table

[Anonymous]

Hi All,

I have create pivot table seller name,quarter as dimension and sales amount as expression.

How can i create pivot table with column %QoQ and Trend as shown in the picture.

Thanks for advance..

[prma7799]

What is your %QoQ Logic based on logic you can create that %QoQ column and after creation of %QoQ simply create new column like

if( %QoQ  < 0  , 'Decline' , 'Growth')

[Anonymous]

Logic for-  %QoQ is (Current quarter-Previous quarter)/Previous quarter. If i add column in pivot it will show for all expression. I need end of the pivot.

[prma7799]

You want like this?

Try below expression

(( ((SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}
>}[Sales Amount])/100000))-

((Sum({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-4))<=$(=Monthend(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>} [Sales Amount])

)/100000))/

fabs(((Sum({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-4))<=$(=Monthend(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>} [Sales Amount])

)/100000)))*100

Or Please share some sample app

[Anonymous]

Yes.. correct.