Please Required Urgent Help

[VishalWaghole]

Hi Community,

Please Find attached Data.

I need Out-Put like this

	Opening Balance (Nov 12  to Mar 13)	May 13	Jun 13	Jul 13
Total files audited	243	48	66	43
Total files with Exception	131	19	42	19
Total files without Exception	112	29	24	24

In Excel Exception Column Contains Y and N Value.

Y = Exception

N = Without Exception.

Please Could any one have possible to solve this issue.

Thanks and Regards,

Vishal Waghole

[#2]

By using calculated dimension.. you can achieve this..

Go thought below link..

(See G Wassennar reply)

http://community.qlik.com/message/358633#358633

Karthik

[adamwilson]

Here are the figures you need, having it in the one table you may have to use a calculated dimension like Karthikeyan S suggested

[tresB]

PFA. Hope this helps.

[VishalWaghole]

Hi

You right but i want that charts only based on expression not on dimension.

By default we can make total by adding month but i want that total which is based on expression.

Thanks for your reply.

[tresB]

PFA.

I have shown both dynamic(colored ones) and static ways