Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the above image MAR-2014 is showing in seperate column i need to be included in the column like the months of apr, may, jun.
so i need to convert the column in to the second column as a row
Hi,
Can you post your sample application.
Regards
ASHFAQ
Take a pivot table and pull the month dimension across to column.
the actual thing is that in sample application if i click the financial year 2014 i need to get from march-2013 to march-2014 means total 13 months of data as comparison to the closing stock of last financial year ..
my financial year starts from april to march..
in the above straight table i need to get the month of march -2014 to be included in it
by pulling column it promote or demote the particular column but is not moving above the apr-2015
Please check the sample attached..
Hi bro,
What did u do plz check my sample app and the image i know to create a chart and change rows in to column but in my image it i need to interchange the place of my expression into the place of dimension and the other option is i have used one calculated dimension as 'month-&financialyear' in one dimension and the other thing that i need to add is this calculated dimension to get the desired result
Month(vMinDate)&'-'&(vPrev_FinYear)