hey

[#1]

i have a field name Region which has north,south,east,west...my customer is asking that i should give him a functionality of north and South,East and West.......so that the region has 6 fields i.e, north,south,east,west,North and South,East and West

[#2]

Hi Sanchit,

Can you please give a bit more details as I am unclear what you are trying to achieve.

Thanks,
Marius

[rajat2392]

please provide a sample data so that I can create a solution and send back to you..

[#4]

Hi Sanchit,

How do you define the new  "North and South" region? Is that the sum of the north and south data?

If yes, that you can't add the new region to the same dimension because it is an aggregation.

I think that what you trying to achieve is to transform this:

into this:

That way you can display the data by the "top" region and than drill down to "sub" regions.

In your script you could use something like this:

pick(wildmatch(Region, 'North', 'South', 'East', 'West'),'North and South', 'North and South', 'East and West', 'East and West') as [TopRegion]

Cheers,

Paul

[ngulliver]

Hi,

You will need clarification from the customer exactly what he means by North East etc. Are they asking for it to be a combination of North and East values or something more individual. Or is the input data going to change ?

[rajat2392]

I think you require this, check the application attached if it helps...

[rajat2392]

or you can simply do this...

[#8]

Hi Rajat,

But if the N-S and E-W are the sums of their respective regions than you are mixing different levels of granularity in the same dimension. This will lead to incorrect calculations (unless you use set analysis).

Cheers,

Paul

[rajat2392]

what is the requirement exactly then?

your customer is asking for two more values N-S and E-W in the dimension Region..what would be their values then..their sum up only or something else?

[#10]

what you showed is exactly what i want but i cant use if statement as my data set is large