pivot or straight tables

[sakamsureshbabu]

hi

BRANCHCODE	GROSS WEIGHT	GROSS AMOUNT	BRAND
CHN	4119025.31	₹ 8803210351.39	44114.345
ERD	3737681.48	₹ 8448415540.61	67664.341
VSG	3468710.73	₹ 7618574411.12	53959.261
SLM	3095072.86	₹ 6509850581.15	20332.514
THP	2875709.47	₹ 6590547784.63	33794.823
KKD	2070999.78	₹ 4818731852.33	105066.807
BVM	318803.86	₹ 802308566.66	11955.417

here BRAND have five values sum, but i need those values in line by line how it is impassible in pivot & straight tables  

BRAND

this convert into

BRAND
BRAND1 BRAND2

[mazacini]

Hi

It can certainly be done with a Pivot.

Say you want to analyse by Gross Weight.

Add the dimension Brand.

Add expression: sum([GROSS WEIGHT])

This will result in a table with Brands listed in the left hand column.

Simply drag the column up to the top row.

Hover over Columns label BRAND. Click+drag - you will see a blue arrow appear as a guide -drag it over the label for the column containing the expression on the right hand side.

Release the mouse.

Hope that helps.

Joe