Hi all i got the solution:

Select Type,Sum(Count)Count,0 as sales From (select Type,Count from #test unpivot(Count for Type in([cropcnt],[SeedCnt])) as upvt1)b

Group by Type

union all

Select Type,0 as Count,Sum(Sales)Sales From (select Type,sales from...

Hi All,

I got the solution:

Select Type,Sum(Count)Count,0 as sales From (select Type,Count from #test unpivot(Count for Type in([cropcnt],[SeedCnt])) as upvt1)b

Group by Type

union all

Select Type,0 as Count,Sum(Sales)Sales From (select Type,sales from #test...

Hi ,

Thanks for the reply. Any how i got the solution

WITH SET Top10Cust AS

[DimGeographyBuyer].[State].[State]

set topP as

Generate( {Top10Cust}, CrossJoin( {[DimGeographyBuyer].[State].CurrentMember},

TopCount([DimProduct].[MaterialId].[MaterialId].Members, 1, ([Measures].[DistributorSalesSum]))))

SELECT

{([Measures].[DistributorSalesSum]) } ON COLUMNS ,

non empty {topP}

ON...

Hi,

I required output in mdx not in sql server . Any how i got the solution FYI

WITH SET Top10Cust AS

[DimGeographyBuyer].[State].[State]

set topP as

Generate( {Top10Cust}, CrossJoin( {[DimGeographyBuyer].[State].CurrentMember},

TopCount([DimProduct].[MaterialId].[MaterialId].Members, 1, ([Measures].[DistributorSalesSum]))))

SELECT

{([Measures].[DistributorSalesSum]) }...

Hi All,

Please Update me If any one knows.

Thakns & Regards,

Naru

The above code is not working for 29,30 th dates for all months

Hi,

Thanks for your reply, actually in my table date column data type is nvarchar and data is following

20110830

20110829

The output is coming following bellow format

NAME ...

Hi,

Some dates it will coming invalid. Why it happen?

For example 29-10-2011,30-08-2011 dates... --it will come Invalid

Than q for all Now it is working fine............

hi bellow format is mix with another month also but i need separate month wise

datesendscntempcodeempname

2011-02-0431 Jan 2011 - 07 Feb 20111104d

2011-02-0431 Jan 2011 - 07 Feb 20111104d

2011-02-0431 Jan 2011 -...

Hi the above link i can not get the solution to my query