Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We are having store(12,15,17,..),date and measure as sum(sales).I need to show this detail in bar chart as below image.
Thanks..
Qvw attached
I suggest that you upload a sample model containing some representative data and more detailed specification for rthe chart that you require.
Preparing examples for Upload - Reduction and Data Scrambling
You want to show specifIc three date sales
Hi,
I need to show daily sales so here my date would be on x-axis,in side bar as store numbers and expression as sum(sales).
Thanks..
Hi,
Please find the attached sample data.
Thanks..
Have you tried from access tab of right and left radio buttons
Do you want the output something like this?
As per your requirement, only the data can be viewed as store number or sum of sales. Both can't be viewed in same bar chart as you shown. There is one more option i can provide you. Try this.
Dimensions:
1. Date(Date,'DD-MMM')
2. Store
Expression:
dual('Store '& Sum(store) & chr(13) &'Sales '& sum(sales),sum(sales))
Also enable 1. Values on Data Points in Expression Tab.
2. Plot Values Inside Segments in Presentation Tab.
3. Vertical in Presentation Tab.
Regards,
Sri
Hi,
Almost there but need to plot stores inside the bars..
Thanks..
The output will be like this.
