Pivot table count total regardless of the row

[wanyunyang]

I'm not able to show the company data, so I made up a similar senario:

A fruit store sells apple and banana. They have t1 to track the sales, t2 for linking, t3 for tracking number of visiting the store:

t1:

Type       key     Sales

Apple      1          20

Banana   2          40

t2:

Key       Date

1         07/01

2         07/02

t3:

Date     Visit

07/01     7

07/02     10

I'm creating a pivot table with row: Type, with measures: Sales and Visit. Now it looks like:

It's counting Visits by Type as well. But I want to show total visits at both Apple and Banana. which should be like:

Is it possible to do it from the layout?

Thanks for help!!!

[ogautier62]

Hi,

sum(total <Type> Visit) as a new mesure for visit should do it as far as type is a dimension

regards

[agigliotti]

maybe with a new measure as below:

sum( total Visits )

[nsetty]

t1:

Load * inline [

Type,Key,Sales

Apple,1,20

Banana,2,40

];

t2:

Load * inline [

Key,Date

1,07/01

2,07/02

];

t3:

Load * inline [

Date,Visit

07/01,7

07/02,10

];

Measure: sum(Total [t1.Visit])