Pivot Table(Calendar and Financial Year)

israrkhan — Wed, 25 Mar 2015 09:17:39 GMT

Hi Guys,

Good Day...!

I created a pivot table, with two dimensions and 5, 6 expressions

my dimensions are Company, Division, and my expressions are Sale, Cost Of Sale, Profit, Expenses, Gross Profit...and so on

every thing is very simple and running as expected.

But my My problem is "one of the company using financial year while other all companies using calendar year"

i have one transaction table, with daily basis transactions.

now in pivot table i want to show financial month and financial year data(for that particular company).

and others all as calendar year, which is already done..!

now let say if i click Feb in Month And 2015 in Year , my pivot table shows data for Feb for all companies,

but i want to show October 2014 data in that specific company column, financial starting month is September.

if i select Jan, Feb, Mar, 2015 then i want to show Sep, Oct, Nov 2014 Data for that specific company column.

kindly let me know, how to handle this requirement, what will be the best way to achieve this.

Many Thanks

Khan

topic Pivot Table(Calendar and Financial Year) in QlikView