VERY VERY Urgent help required Please

[Swaraj8565]

Hi 

This is a cohort chart the repetition depends on the divide number 

Attached the Image of the workflow.

Product	Divide		Jan	Feb	March	Apr
A	2	Jan	1
A	2	Feb	1	2
A	2	Mar		2	3
A	2	Apr			3	4

Very urgently required please help

Input table is 

Product	Divide	Jan	Feb	Mar	Apr
A	2	1	2	3	4

Hoping for a best possible earliest response

DELETE

• View all messages
• Next 

[danilang]

Hi @Swaraj8565 

You said "Nowadays we need the use of cohort everywhere"  What is "Cohort"? can you send me a link? Are you referring to cohort analysis?

Dan 

[Swaraj8565]

This is an example of cohort

Requesting you again to give me the solution workflow if any for this problem 

INPUT:

Product	Divide	Jan	Feb	mar	Apr
A	4	1	2	3	4
B	3	1	2	3	4
C	2	1	2	3	4

output should be 

Product	Divide	Jan	Feb	mar	Apr
A	4	1
A	4	1	2
A	4	1	2	3
A	4	1	2	3	4
A	4		2	3	4
A	4			3	4
A	4				4
B	3	1
B	3	1	2
B	3	1	2	3
B	3		2	3	4
B	3			3	4
B	3				4
C	2	1
C	2	1	2
C	2		2	3
C	2			3	4
c	2				4

[danilang]

@Swaraj8565 

Post what you have so far, and I'll help you through it.

Dan

[huynv96 · Accepted solution]

Oh, sorry, I did not consider divide column. Here is solution

Change Generate Row (4) value 4 with your month on input

Output:

[Swaraj8565]

Hey

Thanks a lot 

for giving your valuable time for solving my problem.

Thanks again 

Regards

Swaraj

[Swaraj8565]

Hey @danilang

Its not working out in cross tab request you to kindly help

Please

[danilang · Accepted solution]

Hi @Swaraj8565 

Good work.  You were very close.  Delete the recordID and Group By [Product] and [Divide] in the Multi row.  Change the Summarize to count distinct month names and add a group by on RowCount in the Cross tab

Dan