topic Double layer dimensions in App Development

Double layer dimensions

kiansin — Fri, 19 Aug 2022 02:59:32 GMT

Hi !

I have the Current year total sales table by invoicing week

the "202140" , "202141" etc was represent the invoicing week

I want the output like this , add the months at the top of 4 of invoicing weeks,

is it possible ?

Thanks in advance !!

Re: Double layer dimensions

SunilChauhan — Fri, 19 Aug 2022 05:28:06 GMT

create a new column using if

if(fieldname>=202140 and fieldname<=202143,'Oct',if(fieldname>=202144 and fieldname<=202147,'Nov')) as New dimension

add this new column to pivot table

Re: Double layer dimensions

justISO — Fri, 19 Aug 2022 05:36:30 GMT

Hi, you can convert your [yearweekfield] to date (and month) with this:

=Month(MakeWeekDate(left([yearweekfield],4), right([yearweekfield],2)))

And yes, add these fields to Pivot table, where on this new month field 'Show totals' are switch on to get Total column, and in Presentation tab 'Fully expanded' is checked to see these '2 layer dimensions'.

Re: Double layer dimensions

kiansin — Fri, 19 Aug 2022 05:46:03 GMT

hi IamBack,

only possible in pivot table ?

Did we manage to make it present by table view?

Re: Double layer dimensions

kiansin — Fri, 19 Aug 2022 05:47:05 GMT

Hi JustISO,

only can make it in Pivot table way?

What if I just want make it by normal table view?

Is it possible ?

Re: Double layer dimensions

SunilChauhan — Fri, 19 Aug 2022 05:48:12 GMT

what you have shown in image is Pivot table view . So i am afraid its not possible in table.