[SOLVED] Display Dimension in the same row as another Dimension

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8747095096

July 23, 2018, 11:28 AM

zcbillions

[SOLVED] Display Dimension in the same row as another Dimension

Hi all,

I have a fairly easy question but I don't know how to accurately describe it to find an answer to it..

I want to display Country in a column, and under each country I want categories displayed, ex. OPEX, REVENUE, etc.. all in the same column. Then I will have other columns displaying facts for each category by country. I have a screen shot of the excel report I'm trying to replicate: https://imgur.com/a/yEX6Zj3

Thank you in advance!

This message has been edited. Last edited by: FP Mod Chuck,

July 23, 2018, 11:53 AM

pav

Hi,

Can you please re - paste your image again.
I can't open your image.

July 23, 2018, 12:00 PM

zcbillions

I reposted it with just the imgur link.

Thanks!

July 23, 2018, 01:36 PM

MartinY

Something such as this ?

TABLE FILE CAR
SUM SEATS OVER RETAIL_COST OVER DEALER_COST
ACROSS COUNTRY
END

July 23, 2018, 02:34 PM

pav

TABLE FILE CAR
SUM
COUNTRY
CAR
COMPUTE FLD_1/A500V=IF COUNTRY NE LAST COUNTRY THEN CAR ELSE FLD_1 |' '| CAR;
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON TABLE HOLD AS HOLD_1
END
-RUN

-*DEFINE FILE HOLD_1
-*CRLF/A2= HEXBYT(13,'A1') | HEXBYT(10,'A1');
-*END

TABLE FILE HOLD_1
SUM
COUNTRY AS ''
FLD_1 NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBFOOT

"

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,WRAP=1,LINEBREAK='CRLF',$
TYPE=SUBFOOT,BY=COUNTRY,COLOR=RED,$
ENDSTYLE
END
-RUN

and calling fld_1 in subfooting.

I dont know why can't paste the code completely.
When I paste the code, I miss some code.

July 24, 2018, 01:06 PM

Doug

Are you pasting it within the </> brackets as shown in the above toolbar? If not, please do so.

quote:
I dont know why can't paste the code completely.
When I paste the code, I miss some code.

July 24, 2018, 01:53 PM

pav

TABLE FILE CAR
SUM
COUNTRY
CAR 
COMPUTE FLD_1/A500V=IF COUNTRY NE LAST COUNTRY THEN CAR ELSE FLD_1 |' '| CAR; 
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON TABLE HOLD AS HOLD_1
END
-RUN

-*DEFINE FILE HOLD_1
-*CRLF/A2= HEXBYT(13,'A1') | HEXBYT(10,'A1');
-*END

TABLE FILE HOLD_1
SUM
COUNTRY AS ''
FLD_1 NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBFOOT
""
"<FLD_1"
""
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,WRAP=1,LINEBREAK='CRLF',$
TYPE=SUBFOOT,BY=COUNTRY,COLOR=RED,$
ENDSTYLE
END
-RUN