Set Analysis

[#1]

Dear Communty

This is my Requirement

i want three months comparision

that is

current year max month        by default monthend           last year current month

Table
Sector / Product / Rating	Current month  max year		finanacial year end that means march		current month previous year
	Amt	% of Total	Amt	% of Total	Amt	% of Total
Erg
Tel
Trn
Oth
Total

Table
Sector / Product / Rating	Jun 12		Mar 12		Jun 11
	Amt	% of Total	Amt	% of Total	Amt	% of Total
Erg
Tel
Trn
Oth
Total

[sujeetsingh]

its all unclear??

[#3]

Hai

I need 3 months comparision

that

current month current year      end of the financial month   and last year current month

its dynamic selection should change 

how i get this one

[#4]

Hi Ram,

Create 3vars one is for currentmonth, current year, Fiscal Month

ForCurrent month year= $(vCurrentmonth)'-'&$(vCurrentyear)

For lastyear currentmonth= $(vCurrentmonth)'-'&$(vCurrentyear)-1

For Fiscalmonth= if fiscal month is equal to previousmonth then use  $(vCurrentmonth)-1 else if it is equal to forwardmonth then use  $(vCurrentmonth)+1

note: current montnh and year will take current selections..

//

chandra

[#5]

hai pls find the attachment

[#6]

Hi Ram,

Created table chart under Sheet8 and i used normalyear if you want fiscal year replace normal year with fiscal year.. i don't know the formula for Total but you can able to write the total formula based set functions..

Regarding Alignment create inline table like

load * inline [

Dim

Amount

Total%

];

use Dim as dimension and write expression for Amount like

=sum({<Month={'Mar'},Year={$(NORMALMAXYR),Dim={Amount}>}AmountF)

Try this..

[#7]

hai

2012 nov  2012mar   2011nov

this structure iwant suppose if i select  2011

then it should change  2011 nov 2011 mar 201o nov

how i can do this thing