Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Excel data sheet for particular user data(numeric) is present in date wise.I want to show those data in Bars according to month wise with sum(present data(numeric)).
Example:-for the months of February data is 4,5,6
output should be for the month February is 15.Means in bar for month of February should be 15 as one bar which is sum.
Can any one give some idea on this?
Hi
Assuming that you are loading the date from Excel in the field name 'Date', then add a month field like this:
LOAD
...
Date,
Month(Date) As Month,
...
FROM ....
and then use Month as the dimension.
Hope that helps
Jonathan
PS this is a very simple solution. If your data spans multiple years, you may need to do the same with Year(Date), or use a master calendar (search this site for more information).
Date is stored in dd/mm/yy format in data sheet while implementing above, month is coming in numeric format , which is the general format in excel for that date/month.I have taken Month as a dimension and sum(Data) as expression
Can any one give some idea on this?
Can any one give some information on above situation?
Hi,
Hope attached file helps you.
Regards,
Jagan.
Answer is not clear, in attached sheet no data present.