Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago
Solved

LINESTX multiple categories

Hello Guys, 

 

I'm new with the Linestx function, 

 

i'd like to get the table with the slope etc, 

 

However my fact table is particular, this table is called 'get'

 

it has types of movements like this 

Item IDMovement typequantitymain warehousesub warehouseMovement Date    
ASales-1MAINWASUBW02/08/2023    
BTransfer out-1MAINWBSUBWBA01/08/2023    

 

and a Calendar (habitual one) with date, month name, blablabla, called 'Calendar'

 

I would like to create a linestx with calendar dates, and get table, with quantitites, per item (i also habe an article table called 'Base Article', that i'd prefer to use if possible), And per Warehouse.

 

so the regression should be done 

 

with sales of items per date per warehouses, is this possible?

 

i have tried with using a summarized table like this

 

Frequence ventes = 

SUMMARIZE(

    FILTER(

        get,

        get[LIBELLE NATURE DE MOUVEMENT] = "Ticket"

    ),

    get[CLEF UNIQUE ARTICLE],

    get[DATE PIECE],

    get[DEPOT],

    get[Ventes],

    "Nb qté ventes (chiffre)", COUNTROWS(get)

)

but i cannot achieve what i'm looking for , ever after having searched hours and hours 😛

 

Thanks in advance for any hints or help ! 

2 Replies