Forum Discussion
BI_Noob
4 years agoFrequent Visitor
Sum Aggregated Values With Multiple Filters based on Dynamic Range
Please Help I have a large dataset with sales information aggregated by date, store#, and most imporantly by hour. See Below Date _ StoreId _ Hour _ Online Orders _ Phone Orders _ Total Order...
amitchandak
4 years agoSuper User
BI_Noob , Please provide the same in table format. So that I can try. Copy paste from excel.
BI_Noob
4 years agoFrequent Visitor
Hi Amit,
Please see below;
Sorry copy and paste from excel causes an error so I had to create link to file. Let me know if this helps explain. I sincerely appreciate your help.