Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmedwank
Contributor III
Contributor III

cumulative sum %

hello

i've tried  to calculate a cumulative sum in % but i didnt succeed,  that's a simple table as a graphic and i would like to cumulate the calculated column "count(commandes.code_article)" displayed in % 

if someone can help me please

thanks

1 Solution

Accepted Solutions
QFabian
Specialist III
Specialist III

Hi @ahmedwank , i just created a dummy table with this :

LOAD * INLINE [
F1, F2
6963, 3
6866, 2
6954, 7
];

Then i created a straight table with :

QFabian_0-1609369192131.png

 

First expression :

QFabian_1-1609369228964.png

Second expression :

QFabian_2-1609369257779.png

and the third :

QFabian_5-1609369734658.png

 

and looks like this :

QFabian_6-1609369782388.png

you can use it with your own data and see whats happens.

 

QFabian

View solution in original post

2 Replies
QFabian
Specialist III
Specialist III

Hi @ahmedwank , i just created a dummy table with this :

LOAD * INLINE [
F1, F2
6963, 3
6866, 2
6954, 7
];

Then i created a straight table with :

QFabian_0-1609369192131.png

 

First expression :

QFabian_1-1609369228964.png

Second expression :

QFabian_2-1609369257779.png

and the third :

QFabian_5-1609369734658.png

 

and looks like this :

QFabian_6-1609369782388.png

you can use it with your own data and see whats happens.

 

QFabian
ahmedwank
Contributor III
Contributor III
Author

Thanks, that's perfect !