How to get exactly similar output ?

[shekhar_analyti]

Hi Team ,

How to get output exactly similar with a simple excel data ?

OUTPUT 1 ,2 , 3 are my requirements .

Thanks & Regards

Shekar

[shekhar_analyti]

tresesco‌ ..

[YoussefBelloum]

Hi,

PFA

[shekhar_analyti]

Hi Yosuf ,

I did not find highlighted calculation .

[shekhar_analyti]

stalwar1‌ ..

[sunny_talwar]

What is U_C? I mean what is the logic behind U_C?

Also, you want two charts or a single chart to behave like below (with and without selection)

[shekhar_analyti]

Thank Sunny Bhai for replying ......U_C is distinct count of people name .. like KESHAV , PARUAL,ASIF,JACOB,PREM--- THESE ARE FIVE DISTINCT PEOPLE IN JAN .......

Three distinct charts will also work fine for me @ this point of time ......

[YoussefBelloum]

You didn't described what is the UC topP MC... maybe you should

[shekhar_analyti]

sorry ...

KESHAV	PARUL	PREM	ASIF	JACOB
2	2	1	1	2

2+2+1+1+2 = 8  ---> Tot_p

Distinct count of Student for Jan = 5  --> U_c

8+5 = 13 --> m_c

[sunny_talwar · Accepted solution]

This