Double layer dimensions

[kiansin]

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 !!

[SunilChauhan]

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 

[justISO]

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'.

[kiansin]

hi IamBack,

only possible in pivot table ?

Did we manage to make it present by table view? 

[kiansin]

Hi JustISO,

only can make it in Pivot table way?

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

Is it possible ?

[SunilChauhan]

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